View: PJM_PROJECT_SO_V

Product:	PJM - Project Manufacturing
Description:	Project-related sales order information for the Web Inquiry.
Implementation/DBA Data:	APPS.PJM_PROJECT_SO_V

View Text

SELECT DISTINCT OOL.PROJECT_ID
, OOL.TASK_ID
, OOH.HEADER_ID
, OOH.ORDER_NUMBER
, OOH.CUST_PO_NUMBER
, OOH.ORDER_CATEGORY_CODE
, OTYPE.NAME
, MIF.ITEM_NUMBER
, MIF.DESCRIPTION
, OOL.END_ITEM_UNIT_NUMBER
, FRTRM.MEANING
, OTERM.NAME
, SOLDTO.CUSTOMER_ID
, SOLDTO.CUSTOMER_NUMBER
, SOLDTO.NAME
, OOH.ORDERED_DATE
, OOH.REQUEST_DATE
, DECODE(OOL.ORDERED_QUANTITY
, 0
, 'Y'
, 'N')
, PJM_INQUIRY.OE_ORG_ADDRESS ( NVL( OOL.SHIP_TO_ORG_ID
, OOH.SHIP_TO_ORG_ID )
, 'SHIP TO' )
, NVL( OOL.SHIP_TO_ORG_ID
, OOH.SHIP_TO_ORG_ID )
, NVL( OOL.SHIPPING_METHOD_CODE
, OOH.SHIPPING_METHOD_CODE )
, SHIP_PR.MEANING
, OOH.PARTIAL_SHIPMENTS_ALLOWED
, NVL( OOL.INVOICE_TO_ORG_ID
, OOH.INVOICE_TO_ORG_ID )
, PJM_INQUIRY.OE_ORG_ADDRESS ( NVL( OOL.INVOICE_TO_ORG_ID
, OOH.INVOICE_TO_ORG_ID )
, 'BILL TO' )
, TO_CHAR( PJM_INQUIRY.OE_ORDER_TOTAL ( OOH.HEADER_ID )
, FND_CURRENCY_CACHE.GET_FORMAT_MASK (OOH.TRANSACTIONAL_CURR_CODE
, 40) )
, OOH.TRANSACTIONAL_CURR_CODE
, NVL(OOL.TAX_EXEMPT_FLAG
, OOH.TAX_EXEMPT_FLAG)
FROM OE_ORDER_LINES OOL
, OE_ORDER_HEADERS OOH
, OE_TRANSACTION_TYPES_VL OTYPE
, OE_RA_TERMS_V OTERM
, OE_SOLD_TO_ORGS_V SOLDTO
, OE_LOOKUPS FRTRM
, OE_LOOKUPS SHIP_PR
, MTL_ITEM_FLEXFIELDS MIF
WHERE OOH.HEADER_ID = OOL.HEADER_ID
AND OTERM.TERM_ID (+) = OOH.PAYMENT_TERM_ID
AND OTYPE.TRANSACTION_TYPE_ID = OOH.ORDER_TYPE_ID
AND SOLDTO.ORGANIZATION_ID (+) = OOH.SOLD_TO_ORG_ID
AND FRTRM.LOOKUP_TYPE (+) = 'FREIGHT_TERMS'
AND FRTRM.LOOKUP_CODE (+) = OOH.FREIGHT_TERMS_CODE
AND SHIP_PR.LOOKUP_TYPE (+) = 'SHIPMENT_PRIORITY'
AND SHIP_PR.LOOKUP_CODE (+) = OOH.SHIPMENT_PRIORITY_CODE
AND MIF.ORGANIZATION_ID = OE_PROFILE.VALUE( 'SO_ORGANIZATION_ID' )
AND MIF.INVENTORY_ITEM_ID = OOL.INVENTORY_ITEM_ID

Columns