VIEW: APPS.POBV_PURCHASE_CONTRACTS

Source

View Text - Preformatted

SELECT ph.PO_HEADER_ID, ph.SEGMENT1, ph.ORG_ID, op.NAME, ph.REVISION_NUM, ph.REVISED_DATE, ph.COMMENTS, '_LA:ph.AUTHORIZATION_STATUS:PO_LOOKUP_CODES:AUTHORIZATION STATUS:DISPLAYED_FIELD', ph.APPROVED_DATE, '_LA:ph.CANCEL_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD', '_LA:ph.CLOSED_CODE:PO_LOOKUP_CODES:DOCUMENT STATE:DISPLAYED_FIELD', ph.CLOSED_DATE, '_LA:ph.FIRM_STATUS_LOOKUP_CODE:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD', '_LA:ph.FROZEN_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD', '_LA:ph.USER_HOLD_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD', ph.RATE, ph.RATE_DATE, '_LA:ph.FREIGHT_TERMS_LOOKUP_CODE:PO_LOOKUP_CODES:FREIGHT TERMS:DISPLAYED_FIELD', '_LA:ph.FOB_LOOKUP_CODE:AR_LOOKUPS:FOB:MEANING', ph.START_DATE, ph.END_DATE, ph.AMOUNT_LIMIT, ph.NOTE_TO_RECEIVER, ph.NOTE_TO_VENDOR, '_LA:ph.ACCEPTANCE_REQUIRED_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD', ph.ACCEPTANCE_DUE_DATE, '_LA:ph.CONFIRMING_ORDER_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD', ph.PRINT_COUNT, ph.PRINTED_DATE, ph.EDI_PROCESSED_FLAG, ph.EDI_PROCESSED_STATUS, ph.USSGL_TRANSACTION_CODE, ph.VENDOR_ID, ph.VENDOR_SITE_ID, ph.VENDOR_CONTACT_ID, ph.AGENT_ID, ph.BILL_TO_LOCATION_ID, ph.SHIP_TO_LOCATION_ID, ph.TERMS_ID, ph.SHIP_VIA_LOOKUP_CODE, ph.CURRENCY_CODE, ph.RATE_TYPE, ph.CREATION_DATE, ph.CREATED_BY, ph.LAST_UPDATE_DATE, ph.LAST_UPDATED_BY, '_LA:ph.CONTERMS_EXIST_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD', PH.CONTERMS_ARTICLES_UPD_DATE, PH.CONTERMS_DELIV_UPD_DATE, PH.DOCUMENT_CREATION_METHOD, PH.SUBMIT_DATE FROM PO_HEADERS_ALL PH, HR_ALL_ORGANIZATION_UNITS OP WHERE PH.TYPE_LOOKUP_CODE = 'CONTRACT' AND PH.ORG_ID = OP.ORGANIZATION_ID WITH READ ONLY

View Text - HTML Formatted

SELECT PH.PO_HEADER_ID
, PH.SEGMENT1
, PH.ORG_ID
, OP.NAME
, PH.REVISION_NUM
, PH.REVISED_DATE
, PH.COMMENTS
, '_LA:PH.AUTHORIZATION_STATUS:PO_LOOKUP_CODES:AUTHORIZATION STATUS:DISPLAYED_FIELD'
, PH.APPROVED_DATE
, '_LA:PH.CANCEL_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, '_LA:PH.CLOSED_CODE:PO_LOOKUP_CODES:DOCUMENT STATE:DISPLAYED_FIELD'
, PH.CLOSED_DATE
, '_LA:PH.FIRM_STATUS_LOOKUP_CODE:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, '_LA:PH.FROZEN_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, '_LA:PH.USER_HOLD_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, PH.RATE
, PH.RATE_DATE
, '_LA:PH.FREIGHT_TERMS_LOOKUP_CODE:PO_LOOKUP_CODES:FREIGHT TERMS:DISPLAYED_FIELD'
, '_LA:PH.FOB_LOOKUP_CODE:AR_LOOKUPS:FOB:MEANING'
, PH.START_DATE
, PH.END_DATE
, PH.AMOUNT_LIMIT
, PH.NOTE_TO_RECEIVER
, PH.NOTE_TO_VENDOR
, '_LA:PH.ACCEPTANCE_REQUIRED_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, PH.ACCEPTANCE_DUE_DATE
, '_LA:PH.CONFIRMING_ORDER_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, PH.PRINT_COUNT
, PH.PRINTED_DATE
, PH.EDI_PROCESSED_FLAG
, PH.EDI_PROCESSED_STATUS
, PH.USSGL_TRANSACTION_CODE
, PH.VENDOR_ID
, PH.VENDOR_SITE_ID
, PH.VENDOR_CONTACT_ID
, PH.AGENT_ID
, PH.BILL_TO_LOCATION_ID
, PH.SHIP_TO_LOCATION_ID
, PH.TERMS_ID
, PH.SHIP_VIA_LOOKUP_CODE
, PH.CURRENCY_CODE
, PH.RATE_TYPE
, PH.CREATION_DATE
, PH.CREATED_BY
, PH.LAST_UPDATE_DATE
, PH.LAST_UPDATED_BY
, '_LA:PH.CONTERMS_EXIST_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, PH.CONTERMS_ARTICLES_UPD_DATE
, PH.CONTERMS_DELIV_UPD_DATE
, PH.DOCUMENT_CREATION_METHOD
, PH.SUBMIT_DATE
FROM PO_HEADERS_ALL PH
, HR_ALL_ORGANIZATION_UNITS OP
WHERE PH.TYPE_LOOKUP_CODE = 'CONTRACT'
AND PH.ORG_ID = OP.ORGANIZATION_ID WITH READ ONLY