VIEW: APPS.POBV_MC_PO_DISTRIBUTIONS

Source

View Text - Preformatted

SELECT PD.SET_OF_BOOKS_ID , SB.NAME , PD.PO_DISTRIBUTION_ID , PD.DISTRIBUTION_NUM , PD.LINE_LOCATION_ID , PS.SHIPMENT_NUM , PD.PO_LINE_ID , PL.LINE_NUM , PD.PO_HEADER_ID , PH.SEGMENT1 , PD.ORG_ID , OP.NAME , NULL , NULL , NULL , NULL , PS.DROP_SHIP_FLAG , PS.SALES_ORDER_UPDATE_DATE , PD.QUANTITY_FINANCED ,PD.AMOUNT_FINANCED , PD.QUANTITY_RECOUPED , PD.AMOUNT_RECOUPED , PD.RETAINAGE_WITHHELD_AMOUNT , PD.RETAINAGE_RELEASED_AMOUNT , PD.TAX_ATTRIBUTE_UPDATE_CODE FROM GL_SETS_OF_BOOKS SB, PO_HEADERS_ALL PH, PO_LINES_ALL PL, PO_LINE_LOCATIONS_ALL PS, PO_DISTRIBUTIONS_ALL PD, HR_ALL_ORGANIZATION_UNITS OP WHERE PD.LINE_LOCATION_ID = PS.LINE_LOCATION_ID AND PD.PO_LINE_ID = PL.PO_LINE_ID AND PD.PO_HEADER_ID = PH.PO_HEADER_ID AND PD.ORG_ID = OP.ORGANIZATION_ID AND PD.SET_OF_BOOKS_ID = SB.SET_OF_BOOKS_ID WITH READ ONLY

View Text - HTML Formatted

SELECT PD.SET_OF_BOOKS_ID
, SB.NAME
, PD.PO_DISTRIBUTION_ID
, PD.DISTRIBUTION_NUM
, PD.LINE_LOCATION_ID
, PS.SHIPMENT_NUM
, PD.PO_LINE_ID
, PL.LINE_NUM
, PD.PO_HEADER_ID
, PH.SEGMENT1
, PD.ORG_ID
, OP.NAME
, NULL
, NULL
, NULL
, NULL
, PS.DROP_SHIP_FLAG
, PS.SALES_ORDER_UPDATE_DATE
, PD.QUANTITY_FINANCED
, PD.AMOUNT_FINANCED
, PD.QUANTITY_RECOUPED
, PD.AMOUNT_RECOUPED
, PD.RETAINAGE_WITHHELD_AMOUNT
, PD.RETAINAGE_RELEASED_AMOUNT
, PD.TAX_ATTRIBUTE_UPDATE_CODE
FROM GL_SETS_OF_BOOKS SB
, PO_HEADERS_ALL PH
, PO_LINES_ALL PL
, PO_LINE_LOCATIONS_ALL PS
, PO_DISTRIBUTIONS_ALL PD
, HR_ALL_ORGANIZATION_UNITS OP
WHERE PD.LINE_LOCATION_ID = PS.LINE_LOCATION_ID
AND PD.PO_LINE_ID = PL.PO_LINE_ID
AND PD.PO_HEADER_ID = PH.PO_HEADER_ID
AND PD.ORG_ID = OP.ORGANIZATION_ID
AND PD.SET_OF_BOOKS_ID = SB.SET_OF_BOOKS_ID WITH READ ONLY