View: POBV_MC_PURCHASE_ORDERS

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

View Text

SELECT MH.SET_OF_BOOKS_ID
, SB.NAME
, MH.PO_HEADER_ID
, PH.SEGMENT1
, PH.ORG_ID
, OP.NAME
, MH.RATE_DATE
, MH.RATE
, MH.RATE_TYPE
FROM PO_MC_HEADERS MH
, GL_SETS_OF_BOOKS SB
, PO_HEADERS_ALL PH
, HR_ALL_ORGANIZATION_UNITS OP
WHERE MH.PO_HEADER_ID = PH.PO_HEADER_ID
AND PH.ORG_ID = OP.ORGANIZATION_ID
AND MH.SET_OF_BOOKS_ID = SB.SET_OF_BOOKS_ID
AND '_SEC:PH.ORG_ID' IS NOT NULL WITH READ ONLY

Columns