VIEW: PA.PA_PWP_AP_INV_HDR#

Source

View Text - Preformatted

select PA_PWP_AP_HDR_ID PA_PWP_AP_HDR_ID, PROJECT_ID PROJECT_ID, INVOICE_ID INVOICE_ID, INVOICE_NUM INVOICE_NUM, SUPPLIER_NUM SUPPLIER_NUM, VENDOR_ID VENDOR_ID, SUPPLIER_NAME SUPPLIER_NAME, SUPPLIER_SITE_CODE SUPPLIER_SITE_CODE, LINKED_DRAFT_INVOICE_NUM LINKED_DRAFT_INVOICE_NUM, LINKED_DRFAT_INV_TYPE LINKED_DRFAT_INV_TYPE, INVOICE_DATE INVOICE_DATE, INVOICE_AMOUNT INVOICE_AMOUNT, INVOICE_CURRENCY INVOICE_CURRENCY, HOLD_REASON HOLD_REASON, PWP_HOLD_FLAG PWP_HOLD_FLAG, DLV_HOLD_FLAG DLV_HOLD_FLAG, PAYMENT_STATUS PAYMENT_STATUS, RELHOLD_REJ_REASON RELHOLD_REJ_REASON, PO_NUMBER PO_NUMBER, DESCRIPTION DESCRIPTION, EXCHANGE_RATE EXCHANGE_RATE, EXCHANGE_DATE EXCHANGE_DATE, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE, GL_DATE GL_DATE, EARLIEST_PAY_DUE_DATE EARLIEST_PAY_DUE_DATE, INVOICE_TYPE INVOICE_TYPE, PREPAID_AMOUNT PREPAID_AMOUNT, HOLD_APPLIED_YN HOLD_APPLIED_YN, HOLD_FLAG HOLD_FLAG from "PA"."PA_PWP_AP_INV_HDR"

View Text - HTML Formatted

SELECT PA_PWP_AP_HDR_ID PA_PWP_AP_HDR_ID
, PROJECT_ID PROJECT_ID
, INVOICE_ID INVOICE_ID
, INVOICE_NUM INVOICE_NUM
, SUPPLIER_NUM SUPPLIER_NUM
, VENDOR_ID VENDOR_ID
, SUPPLIER_NAME SUPPLIER_NAME
, SUPPLIER_SITE_CODE SUPPLIER_SITE_CODE
, LINKED_DRAFT_INVOICE_NUM LINKED_DRAFT_INVOICE_NUM
, LINKED_DRFAT_INV_TYPE LINKED_DRFAT_INV_TYPE
, INVOICE_DATE INVOICE_DATE
, INVOICE_AMOUNT INVOICE_AMOUNT
, INVOICE_CURRENCY INVOICE_CURRENCY
, HOLD_REASON HOLD_REASON
, PWP_HOLD_FLAG PWP_HOLD_FLAG
, DLV_HOLD_FLAG DLV_HOLD_FLAG
, PAYMENT_STATUS PAYMENT_STATUS
, RELHOLD_REJ_REASON RELHOLD_REJ_REASON
, PO_NUMBER PO_NUMBER
, DESCRIPTION DESCRIPTION
, EXCHANGE_RATE EXCHANGE_RATE
, EXCHANGE_DATE EXCHANGE_DATE
, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE
, GL_DATE GL_DATE
, EARLIEST_PAY_DUE_DATE EARLIEST_PAY_DUE_DATE
, INVOICE_TYPE INVOICE_TYPE
, PREPAID_AMOUNT PREPAID_AMOUNT
, HOLD_APPLIED_YN HOLD_APPLIED_YN
, HOLD_FLAG HOLD_FLAG
FROM "PA"."PA_PWP_AP_INV_HDR"