CMR_XLA_PURCHASE_ORDER_DTLS_V

Details

• Schema: FUSION

• Object owner: CMR

• Object type: VIEW

Columns

Name

CMR_PO_DISTRIBUTION_ID SOLD_TO_BUSINESS_UNIT_ID DELIVER_TO_BUSINESS_UNIT_ID DELIVER_TO_INV_ORG_ID DELIVER_TO_LOCATION_ID ACTIVE_FLAG ITEM_DESCRIPTION ACCRUE_ON_RECEIPT_FLAG PURCHASE_BASIS MATCH_OPTION DESTINATION_TYPE_CODE PO_NUMBER PO_LINE_NUMBER VENDOR_ID VENDOR_NAME EXTERNAL_SYSTEM_REF_ID EXTERNAL_SYSTEM_REFERENCE CHARGE_ACCOUNT_ID VARIANCE_ACCOUNT_ID DEST_CHARGE_ACCOUNT_ID DEST_VARIANCE_ACCOUNT_ID MATCHING_BASIS ACCRUAL_ACCOUNT_ID PUR_CATEGORY_ID PO_DISTRIBUTION_NUMBER PO_SCHEDULE_NUMBER REQ_DISTRIBUTION_NUMBER REQ_LINE_NUMBER REQ_ITEM_DESCRIPTION REQUISITION_NUMBER PO_HEADER_ID PO_LINE_ID VENDOR_TYPE PO_DISTRIBUTION_ATTRIBUTE1 PO_DISTRIBUTION_ATTRIBUTE2 PO_DISTRIBUTION_ATTRIBUTE3 PO_DISTRIBUTION_ATTRIBUTE4 PO_DISTRIBUTION_ATTRIBUTE5 PO_DISTRIBUTION_ATTRIBUTE6 PO_DISTRIBUTION_ATTRIBUTE7 PO_DISTRIBUTION_ATTRIBUTE8 PO_DISTRIBUTION_ATTRIBUTE9 PO_DISTRIBUTION_ATTRIBUTE10 PO_DISTRIBUTION_ATTRIBUTE11 PO_DISTRIBUTION_ATTRIBUTE12 PO_DISTRIBUTION_ATTRIBUTE13 PO_DISTRIBUTION_ATTRIBUTE14 PO_DISTRIBUTION_ATTRIBUTE15 PO_DISTRIBUTION_ATTRIBUTE16 PO_DISTRIBUTION_ATTRIBUTE17 PO_DISTRIBUTION_ATTRIBUTE18 PO_DISTRIBUTION_ATTRIBUTE19 PO_DISTRIBUTION_ATTRIBUTE20 PO_LINE_PRICE PO_LINE_CURRENCY_CODE

Query

SQL_Statement

SELECT /*+ NO_MERGE */ cpod.cmr_po_distribution_id cmr_po_distribution_id, cpod.sold_to_business_unit_id sold_to_business_unit_id, cpod.deliver_to_business_unit_id deliver_to_business_unit_id, cpod.deliver_to_inventory_org_id deliver_to_inv_org_id, cpod.ship_to_location_id deliver_to_location_id, cpod.active_flag active_flag, nvl( cpod.item_description, (SELECT esi.DESCRIPTION FROM egp_system_items_vl esi WHERE esi.inventory_item_id = cpod.inventory_item_id AND esi.organization_id = cpod.deliver_to_inventory_org_id )) item_description, cpod.accrue_on_receipt_flag accrue_on_receipt_flag, cpod.purchase_basis purchase_basis, cpod.match_option match_option, cpod.destination_type_code destination_type_code, cpod.po_number po_number, cpod.line_number po_line_number, cpod.vendor_id vendor_id, ps.vendor_name vendor_name, cpod.external_system_ref_id external_system_ref_id, cpod.external_system_reference external_system_reference, cpod.charge_account_id charge_account_id, cpod.variance_account_id variance_account_id, cpod.destination_charge_account_id dest_charge_account_id, cpod.destination_variance_acct_id dest_variance_account_id, cpod.matching_basis matching_basis, cpod.accrual_account_id accrual_account_id, cpod.category_id pur_category_id, cpod.distribution_number po_distribution_number, cpod.shipment_number po_schedule_number, reqdists.distribution_number req_distribution_number, reqlines.line_number req_line_number, reqlines.item_description req_item_description, reqheader.requisition_number requisition_number, cpod.po_header_id po_header_id, cpod.po_line_id po_line_id, ps.vendor_type_lookup_code vendor_type, pod.attribute1 po_distribution_attribute1, pod.attribute2 po_distribution_attribute2, pod.attribute3 po_distribution_attribute3, pod.attribute4 po_distribution_attribute4, pod.attribute5 po_distribution_attribute5, pod.attribute6 po_distribution_attribute6, pod.attribute7 po_distribution_attribute7, pod.attribute8 po_distribution_attribute8, pod.attribute9 po_distribution_attribute9, pod.attribute10 po_distribution_attribute10, pod.attribute11 po_distribution_attribute11, pod.attribute12 po_distribution_attribute12, pod.attribute13 po_distribution_attribute13, pod.attribute14 po_distribution_attribute14, pod.attribute15 po_distribution_attribute15, pod.attribute16 po_distribution_attribute16, pod.attribute17 po_distribution_attribute17, pod.attribute18 po_distribution_attribute18, pod.attribute19 po_distribution_attribute19, pod.attribute20 po_distribution_attribute20, DECODE(cpod.purchase_basis,'GOODS', cpod.price, cpod.amount_ordered) po_line_price, cpod.currency_code po_line_currency_code FROM cmr_purchase_order_dtls cpod, po_distributions_all pod, por_requisition_headers_all reqheader, por_requisition_lines_all reqlines, por_req_distributions_all reqdists, poz_suppliers_v ps WHERE cpod.external_system_ref_id = pod.po_distribution_id AND cpod.external_system_reference = 'FUSION' AND cpod.po_line_location_id = pod.line_location_id AND cpod.po_header_id = pod.po_header_id AND reqdists.distribution_id (+) = pod.req_distribution_id AND reqdists.requisition_line_id = reqlines.requisition_line_id (+) AND reqlines.requisition_header_id = reqheader.requisition_header_id (+) AND cpod.vendor_id = ps.vendor_id AND cpod.active_flag = 'Y'