eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PJM_PROJECT_SO_V

Source

View Text - Preformatted


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.segment1 , MIF.DESCRIPTION , OOL.END_ITEM_UNIT_NUMBER , pjm_inquiry.oe_lookup(OOH.FREIGHT_TERMS_CODE,'FREIGHT_TERMS') , 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 ) , pjm_inquiry.oe_lookup(OOH.SHIPMENT_PRIORITY_CODE,'SHIPMENT_PRIORITY') , 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) , OOH.ORG_ID FROM OE_ORDER_LINES_ALL OOL , OE_ORDER_HEADERS_ALL OOH , OE_TRANSACTION_TYPES_TL OTYPE , RA_TERMS_TL OTERM , OE_SOLD_TO_ORGS_V SOLDTO , mtl_system_items_b 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 MIF.INVENTORY_ITEM_ID = OOL.INVENTORY_ITEM_ID AND mif.organization_id = OOL.ship_from_org_id AND OTYPE.LANGUAGE = userenv('LANG') AND OTERM.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

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.SEGMENT1
, MIF.DESCRIPTION
, OOL.END_ITEM_UNIT_NUMBER
, PJM_INQUIRY.OE_LOOKUP(OOH.FREIGHT_TERMS_CODE
, 'FREIGHT_TERMS')
, 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 )
, PJM_INQUIRY.OE_LOOKUP(OOH.SHIPMENT_PRIORITY_CODE
, 'SHIPMENT_PRIORITY')
, 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)
, OOH.ORG_ID
FROM OE_ORDER_LINES_ALL OOL
, OE_ORDER_HEADERS_ALL OOH
, OE_TRANSACTION_TYPES_TL OTYPE
, RA_TERMS_TL OTERM
, OE_SOLD_TO_ORGS_V SOLDTO
, MTL_SYSTEM_ITEMS_B 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 MIF.INVENTORY_ITEM_ID = OOL.INVENTORY_ITEM_ID
AND MIF.ORGANIZATION_ID = OOL.SHIP_FROM_ORG_ID
AND OTYPE.LANGUAGE = USERENV('LANG')
AND OTERM.LANGUAGE = USERENV('LANG')