VIEW: APPS.IBE_INVOICE_HEADER_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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