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.

[Home] [Help]

View: POBV_MC_PO_DISTRIBUTIONS

Product:	PO - Purchasing
Description:	- Retrofitted
Implementation/DBA Data:	APPS.POBV_MC_PO_DISTRIBUTIONS

View Text

SELECT MD.SET_OF_BOOKS_ID
, SB.NAME
, MD.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
, MD.RATE_DATE
, MD.RATE
, MD.ENCUMBERED_AMOUNT
, MD.UNENCUMBERED_AMOUNT
, PS.DROP_SHIP_FLAG
, PS.SALES_ORDER_UPDATE_DATE
FROM PO_MC_DISTRIBUTIONS MD
, 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 MD.PO_DISTRIBUTION_ID = PD.PO_DISTRIBUTION_ID
AND 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 MD.SET_OF_BOOKS_ID = SB.SET_OF_BOOKS_ID
AND '_SEC:PD.ORG_ID' IS NOT NULL WITH READ ONLY

Columns

Name
SET_OF_BOOKS_ID
SET_OF_BOOKS_NAME
PO_DISTRIBUTION_ID
DISTRIBUTION_NUMBER
PO_SHIPMENT_ID
SHIPMENT_NUMBER
PO_LINE_ID
LINE_NUMBER
PURCHASE_ORDER_ID
PO_DOCUMENT_NUMBER
OPERATING_UNIT_ID
OPERATING_UNIT_NAME
CURRENCY_CONVERSION_RATE_DATE
CURRENCY_CONVERSION_RATE
ENCUMBERED_AMOUNT
UNENCUMBERED_AMOUNT
DROP_SHIP_FLAG
SALES_ORDER_UPDATE_DATE