View: IBE_INVOICE_HEADER_V

Product:	IBE - iStore
Description:
Implementation/DBA Data:	APPS.IBE_INVOICE_HEADER_V

View Text

SELECT CT.TRX_NUMBER
, CT.TRX_DATE
, CT.INVOICE_CURRENCY_CODE
, AL_CLASS.MEANING TYPE
, CT.PURCHASE_ORDER PO_NUMBER
, CT.WAYBILL_NUMBER
, PS.DUE_DATE DUE_DATE
, PS.AMOUNT_DUE_ORIGINAL
, PS.AMOUNT_DUE_REMAINING
, PS.AMOUNT_LINE_ITEMS_ORIGINAL
, PS.TAX_ORIGINAL
, PS.FREIGHT_ORIGINAL
, PS.AMOUNT_ADJUSTED
, PS.AMOUNT_APPLIED
, PS.AMOUNT_CREDITED
, PS.DISCOUNT_TAKEN_EARNED
, CT.SHIP_VIA
, ACCT.PARTY_ID PARTY_ID
, CT.CUSTOMER_TRX_ID CUSTOMER_TRX_ID
, ACCT.CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, CT.CREATED_BY
, CT.INTERFACE_HEADER_ATTRIBUTE1
, CT.ORG_ID ORG_ID
FROM AR_PAYMENT_SCHEDULES_ALL PS
, RA_CUSTOMER_TRX_ALL CT
, AR_LOOKUPS AL_CLASS
, HZ_CUST_ACCOUNTS ACCT
WHERE PS.CUSTOMER_TRX_ID = CT.CUSTOMER_TRX_ID
AND PS.CLASS = AL_CLASS.LOOKUP_CODE
AND AL_CLASS.LOOKUP_TYPE = 'INV/CM'
AND CT.BILL_TO_CUSTOMER_ID = ACCT.CUST_ACCOUNT_ID

Columns