View: PO_SGD_HEADERS_V

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

View Text

SELECT PH_PO_HEADER_ID PK1_VALUE
, DRAFT_ID PK2_VALUE
, NULL PK3_VALUE
, NULL PK4_VALUE
, NULL PK5_VALUE
, COL_NAME
, COL_VALUE
, DECODE(COL_NAME
, 'ACCEPTANCE_REQUIRED_FLAG'
, (SELECT DISPLAYED_FIELD
FROM PO_LOOKUP_CODES
WHERE LOOKUP_CODE = COL_VALUE
AND LOOKUP_TYPE = 'ACCEPTANCE_REQUIRED')
, 'CLM_CONTRACT_OFFICER'
, (SELECT FULL_NAME
FROM PER_ALL_PEOPLE_F
WHERE PERSON_ID = COL_VALUE
AND TRUNC(SYSDATE) BETWEEN EFFECTIVE_START_DATE
AND EFFECTIVE_END_DATE)
, 'USER_DOCUMENT_STATUS'
, (SELECT DISPLAYED_FIELD
FROM PO_LOOKUP_CODES
WHERE LOOKUP_CODE = COL_VALUE
AND LOOKUP_TYPE = 'PO_USER_DOCUMENT_STATUS')
, 'VENDOR_SITE_ID'
, (SELECT VENDOR_SITE_CODE
FROM PO_VENDOR_SITES_ALL
WHERE VENDOR_SITE_ID = COL_VALUE)
, 'VENDOR_CONTACT_ID'
, (SELECT FULL_NAME
FROM PO_SUPPLIER_CONTACTS_VAL_V PSC
, PO_HEADERS_ALL PHA
WHERE PSC.VENDOR_CONTACT_ID = COL_VALUE
AND PSC.VENDOR_SITE_ID = PHA.VENDOR_SITE_ID
AND PHA.PO_HEADER_ID = PH_PO_HEADER_ID)
, 'SUPPLIER_NOTIF_METHOD'
, (SELECT DISPLAYED_FIELD
FROM PO_LOOKUP_CODES
WHERE LOOKUP_CODE = COL_VALUE
AND LOOKUP_TYPE = 'DOCUMENT_COMMUNICATION_METHOD')
, 'AGENT_ID'
, (SELECT FULL_NAME
FROM PER_ALL_PEOPLE_F
WHERE PERSON_ID = COL_VALUE
AND TRUNC(SYSDATE) BETWEEN EFFECTIVE_START_DATE
AND EFFECTIVE_END_DATE)
, 'CLM_AWARD_ADMINISTRATOR'
, (SELECT FULL_NAME
FROM PER_ALL_PEOPLE_F
WHERE PERSON_ID = COL_VALUE
AND TRUNC(SYSDATE) BETWEEN EFFECTIVE_START_DATE
AND EFFECTIVE_END_DATE)
, 'CONFIRMING_ORDER_FLAG'
, (SELECT MEANING
FROM FND_LOOKUPS
WHERE LOOKUP_CODE = COL_VALUE
AND LOOKUP_TYPE = 'YES_NO')
, 'TERMS_ID'
, (SELECT NAME
FROM AP_TERMS
WHERE TERM_ID = COL_VALUE)
, 'SHIP_TO_LOCATION_ID'
, (SELECT LOCATION_CODE
FROM HR_LOCATIONS_ALL
WHERE LOCATION_ID = COL_VALUE)
, 'FREIGHT_TERMS_LOOKUP_CODE'
, (SELECT DISPLAYED_FIELD
FROM PO_LOOKUP_CODES
WHERE LOOKUP_CODE = COL_VALUE
AND LOOKUP_TYPE = 'FREIGHT TERMS' )
, 'SHIPPING_CONTROL'
, (SELECT DISPLAYED_FIELD
FROM PO_LOOKUP_CODES
WHERE LOOKUP_CODE = COL_VALUE
AND LOOKUP_TYPE = 'SHIPPING CONTROL')
, 'SHIP_VIA_LOOKUP_CODE'
, (SELECT NVL(OFC.FREIGHT_CODE_TL
, COL_VALUE)
FROM ORG_FREIGHT_TL OFC
WHERE OFC.FREIGHT_CODE = COL_VALUE
AND OFC.ORGANIZATION_ID = ORG_ID
AND OFC.LANGUAGE = USERENV('LANG') )
, 'FOB_LOOKUP_CODE'
, (SELECT DISPLAYED_FIELD
FROM PO_LOOKUP_CODES
WHERE LOOKUP_TYPE = 'FOB'
AND LOOKUP_CODE = COL_VALUE)
, NULL) COL_DESC
FROM ( SELECT PH.PO_HEADER_ID PH_PO_HEADER_ID
, NVL(PH.DRAFT_ID
, -1) DRAFT_ID
, PH.ORG_ID
, TO_CHAR(PO_DATATEMPLATE_PKG.GET_HEADER_AMOUNT_ORDERED(PH.PO_HEADER_ID
, NVL(PH.DRAFT_ID
, -1))) TOTAL_AMOUNT
, PH.ACCEPTANCE_REQUIRED_FLAG
, TO_CHAR(PH.ACCEPTANCE_DUE_DATE) ACCEPTANCE_DUE_DATE
, TO_CHAR(PH.CLM_CONTRACT_OFFICER) CLM_CONTRACT_OFFICER
, PH.USER_DOCUMENT_STATUS
, TO_CHAR(PH.VENDOR_SITE_ID) VENDOR_SITE_ID
, TO_CHAR(PH.VENDOR_CONTACT_ID) VENDOR_CONTACT_ID
, PH.SUPPLIER_NOTIF_METHOD
, PH.FAX
, PH.EMAIL_ADDRESS
, PH.CLM_EXTERNAL_IDV
, PH.CLM_VENDOR_OFFER_NUMBER
, TO_CHAR(PH.CLM_EFFECTIVE_DATE) CLM_EFFECTIVE_DATE
, TO_CHAR(PH.AGENT_ID) AGENT_ID
, TO_CHAR(PH.CLM_AWARD_ADMINISTRATOR) CLM_AWARD_ADMINISTRATOR
, PH.COMMENTS
, PH.CONFIRMING_ORDER_FLAG
, TO_CHAR(PH.TERMS_ID) TERMS_ID
, TO_CHAR(PH.CLM_NO_SIGNED_COPIES_TO_RETURN) CLM_NO_SIGNED_COPIES_TO_RETURN
, TO_CHAR(PH.SHIP_TO_LOCATION_ID) SHIP_TO_LOCATION_ID
, PH.SHIP_VIA_LOOKUP_CODE
, PH.FREIGHT_TERMS_LOOKUP_CODE
, PH.FOB_LOOKUP_CODE
, PH.SHIPPING_CONTROL
, PH.NOTE_TO_VENDOR
, PH.NOTE_TO_RECEIVER
, TO_CHAR(PH.BLANKET_TOTAL_AMOUNT) BLANKET_TOTAL_AMOUNT
, TO_CHAR(PH.PRICE_UPDATE_TOLERANCE) PRICE_UPDATE_TOLERANCE
, TO_CHAR(PH.START_DATE) START_DATE
, TO_CHAR(PH.END_DATE) END_DATE
, TO_CHAR(PH.AMOUNT_LIMIT) AMOUNT_LIMIT
, TO_CHAR(PH.CLM_AMOUNT_RELEASED) CLM_AMOUNT_RELEASED
, TO_CHAR(PH.CLM_MAX_ORDER_AMOUNT) CLM_MAX_ORDER_AMOUNT
, TO_CHAR(PH.CLM_MIN_ORDER_AMOUNT) CLM_MIN_ORDER_AMOUNT
, TO_CHAR(PH.CLM_MIN_GUARANTEE_AWARD_AMT) CLM_MIN_GUARANTEE_AWARD_AMT
, TO_CHAR(PH.CLM_MIN_GUAR_AWARD_AMT_PERCENT) CLM_MIN_GUAR_AWARD_AMT_PERCENT
, NULL AS CHANGE_STATUS
FROM PO_HEADERS_ALL PH
WHERE PH.PO_HEADER_ID = PO_GEN_DIFF_PKG.GETBASEPK1
AND NVL(PH.DRAFT_ID
, -1) = PO_GEN_DIFF_PKG.GETBASEPK2 ) PO_HEADER_UNPIVOT_DATA UNPIVOT INCLUDE NULLS ( COL_VALUE FOR COL_NAME IN ( TOTAL_AMOUNT
, ACCEPTANCE_REQUIRED_FLAG
, ACCEPTANCE_DUE_DATE
, CLM_CONTRACT_OFFICER
, USER_DOCUMENT_STATUS
, VENDOR_SITE_ID
, VENDOR_CONTACT_ID
, SUPPLIER_NOTIF_METHOD
, FAX
, EMAIL_ADDRESS
, CLM_EXTERNAL_IDV
, CLM_VENDOR_OFFER_NUMBER
, CLM_EFFECTIVE_DATE
, AGENT_ID
, CLM_AWARD_ADMINISTRATOR
, COMMENTS
, CONFIRMING_ORDER_FLAG
, TERMS_ID
, CLM_NO_SIGNED_COPIES_TO_RETURN
, SHIP_TO_LOCATION_ID
, SHIP_VIA_LOOKUP_CODE
, FREIGHT_TERMS_LOOKUP_CODE
, FOB_LOOKUP_CODE
, SHIPPING_CONTROL
, NOTE_TO_VENDOR
, NOTE_TO_RECEIVER
, BLANKET_TOTAL_AMOUNT
, PRICE_UPDATE_TOLERANCE
, START_DATE
, END_DATE
, AMOUNT_LIMIT
, CLM_AMOUNT_RELEASED
, CLM_MAX_ORDER_AMOUNT
, CLM_MIN_ORDER_AMOUNT
, CLM_MIN_GUARANTEE_AWARD_AMT
, CLM_MIN_GUAR_AWARD_AMT_PERCENT
, CHANGE_STATUS ) )

Columns