VIEW: APPS.POFV_MC_PURCHASE_ORDERS

Source

View Text - Preformatted

SELECT NULL , NULL , PH.PO_HEADER_ID , PH.SEGMENT1 , PH.ORG_ID , OP.NAME , PH.RATE_DATE , PH.RATE , PH.RATE_TYPE , RT.USER_CONVERSION_TYPE , RT.DESCRIPTION ,PH.AUTO_SOURCING_FLAG ,PH.UPDATE_SOURCING_RULES_FLAG ,PH.RETRO_PRICE_APPLY_UPDATES_FLAG ,PH.RETRO_PRICE_COMM_UPDATES_FLAG ,PH.EMAIL_ADDRESS ,PH.FAX ,PH.SUPPLIER_NOTIF_METHOD ,PH.SUPPLIER_AUTH_ENABLED_FLAG ,PH.CAT_ADMIN_AUTH_ENABLED_FLAG ,PH.STYLE_ID ,PH.TAX_ATTRIBUTE_UPDATE_CODE FROM PO_HEADERS_ALL PH, HR_ALL_ORGANIZATION_UNITS OP, GL_DAILY_CONVERSION_TYPES RT WHERE PH.ORG_ID = OP.ORGANIZATION_ID AND PH.RATE_TYPE = RT.CONVERSION_TYPE WITH READ ONLY

View Text - HTML Formatted

SELECT NULL
, NULL
, PH.PO_HEADER_ID
, PH.SEGMENT1
, PH.ORG_ID
, OP.NAME
, PH.RATE_DATE
, PH.RATE
, PH.RATE_TYPE
, RT.USER_CONVERSION_TYPE
, RT.DESCRIPTION
, PH.AUTO_SOURCING_FLAG
, PH.UPDATE_SOURCING_RULES_FLAG
, PH.RETRO_PRICE_APPLY_UPDATES_FLAG
, PH.RETRO_PRICE_COMM_UPDATES_FLAG
, PH.EMAIL_ADDRESS
, PH.FAX
, PH.SUPPLIER_NOTIF_METHOD
, PH.SUPPLIER_AUTH_ENABLED_FLAG
, PH.CAT_ADMIN_AUTH_ENABLED_FLAG
, PH.STYLE_ID
, PH.TAX_ATTRIBUTE_UPDATE_CODE
FROM PO_HEADERS_ALL PH
, HR_ALL_ORGANIZATION_UNITS OP
, GL_DAILY_CONVERSION_TYPES RT
WHERE PH.ORG_ID = OP.ORGANIZATION_ID
AND PH.RATE_TYPE = RT.CONVERSION_TYPE WITH READ ONLY