Product: | PO - Purchasing |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.POFV_MC_PURCHASE_ORDERS |
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
, RT.USER_CONVERSION_TYPE
, RT.DESCRIPTION
FROM PO_MC_HEADERS MH
, GL_SETS_OF_BOOKS SB
, PO_HEADERS_ALL PH
, HR_ALL_ORGANIZATION_UNITS OP
, GL_DAILY_CONVERSION_TYPES RT
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 MH.RATE_TYPE = RT.CONVERSION_TYPE
AND '_SEC:PH.ORG_ID' IS NOT NULL WITH READ ONLY