VIEW: APPS.POBV_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, 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 WHERE PH.ORG_ID = OP.ORGANIZATION_ID 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
, 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
WHERE PH.ORG_ID = OP.ORGANIZATION_ID WITH READ ONLY