CMR_PURCHASE_ORDER_INFO_V

Details

• Schema: FUSION

• Object owner: CMR

• Object type: VIEW

Columns

Name

PO_LINE_LOCATION_ID REQUISITIONING_BU_ID PROCUREMENT_BUSINESS_UNIT_ID DELIVER_TO_BUSINESS_UNIT_ID PURCHASE_INVENTORY_ORG_ID SOURCE_DOCUMENT_NUMBER SOURCE_DOCUMENT_LINE_NUMBER PO_SCHEDULE DESTINATION_TYPE_CODE ITEM_DESCRIPTION CONV_FACTOR_TO_PRIMARY_UOM PRICE QUANTITY_ORDERED TAX_EXCLUSIVE_PRICE NONRECOVERABLE_TAX RECOVERABLE_TAX RECOVERABLE_INCLUSIVE_TAX NONRECOVERABLE_INCLUSIVE_TAX UOM_CODE CURRENCY_CODE PO_CONVERSION_DATE PO_CONVERSION_RATE PO_CONVERSION_TYPE NEED_BY_DATE PROMISED_DATE EVENT_DATE VENDOR_ID VENDOR_SITE_ID ACCRUE_ON_RECEIPT_FLAG MATCH_OPTION PURCHASE_BASIS PTR_FLAG

Query

SQL_Statement

SELECT CPOD.PO_LINE_LOCATION_ID, MAX(NVL(CPOD.REQUISITIONING_BU_ID,0)) REQUISITIONING_BU_ID, MAX(NVL(CPOD.PROCUREMENT_BUSINESS_UNIT_ID,0)) PROCUREMENT_BUSINESS_UNIT_ID, CPOD.DELIVER_TO_BUSINESS_UNIT_ID, MAX(NVL(CPOD.TRADE_ORGANIZATION_ID,0)) PURCHASE_INVENTORY_ORG_ID, CPOD.PO_NUMBER SOURCE_DOCUMENT_NUMBER, CPOD.LINE_NUMBER SOURCE_DOCUMENT_LINE_NUMBER, CPOD.SHIPMENT_NUMBER PO_SCHEDULE, CPOD.DESTINATION_TYPE_CODE DESTINATION_TYPE_CODE, CPOD.ITEM_DESCRIPTION, CPOD.CONV_FACTOR_TO_PRIMARY_UOM, MAX(CPOD.PRICE) PRICE, sum(CPOD.QUANTITY_ORDERED) QUANTITY_ORDERED, MAX(NVL(CPOD.TAX_EXCLUSIVE_PRICE,0)) TAX_EXCLUSIVE_PRICE, sum(CPOD.NONRECOVERABLE_TAX) NONRECOVERABLE_TAX, sum(CPOD.RECOVERABLE_TAX) RECOVERABLE_TAX, sum(CPOD.RECOVERABLE_INCLUSIVE_TAX) RECOVERABLE_INCLUSIVE_TAX, sum(CPOD.NONRECOVERABLE_INCLUSIVE_TAX) NONRECOVERABLE_INCLUSIVE_TAX, CPOD.UOM_CODE, CPOD.CURRENCY_CODE, MAX(CPOD.CURRENCY_CONVERSION_DATE) PO_CONVERSION_DATE, MAX(CPOD.CURRENCY_CONVERSION_RATE) PO_CONVERSION_RATE, MAX(CPOD.CURRENCY_CONVERSION_TYPE) PO_CONVERSION_TYPE, CPOD.NEED_BY_DATE, CPOD.PROMISED_DATE, MAX(CPOD.EVENT_DATE) EVENT_DATE, CPOD.VENDOR_ID, CPOD.VENDOR_SITE_ID, CPOD.ACCRUE_ON_RECEIPT_FLAG, CPOD.MATCH_OPTION, CPOD.PURCHASE_BASIS, DECODE(CPOD.SFO_PRIMARY_TRADE_RELATION_ID, NULL, 'N', 'Y') PTR_FLAG FROM CMR_PURCHASE_ORDER_DTLS CPOD WHERE CPOD.ACTIVE_FLAG = 'Y' GROUP BY CPOD.PO_LINE_LOCATION_ID, CPOD.DELIVER_TO_BUSINESS_UNIT_ID, CPOD.PO_NUMBER , CPOD.LINE_NUMBER , CPOD.SHIPMENT_NUMBER , CPOD.DESTINATION_TYPE_CODE , CPOD.ITEM_DESCRIPTION, CPOD.UOM_CODE, CPOD.CURRENCY_CODE, CPOD.NEED_BY_DATE, CPOD.PROMISED_DATE, CPOD.VENDOR_ID, CPOD.VENDOR_SITE_ID, CPOD.ACCRUE_ON_RECEIPT_FLAG, CPOD.MATCH_OPTION, CPOD.PURCHASE_BASIS, DECODE(CPOD.SFO_PRIMARY_TRADE_RELATION_ID, NULL, 'N', 'Y'), CPOD.CONV_FACTOR_TO_PRIMARY_UOM