AR_DOCS_RECEIVABLES_V

Details

• Schema: FUSION

• Object owner: AR

• Object type: VIEW

Columns

Name

ORDER_TANGIBLE_ID ORDER_EXT_ID DOC_UNIQUE_REF CALLING_APP_DOC_REF_NUMBER PO_NUMBER VAT_REF_NUMBER DOCUMENT_DATE DOCUMENT_TYPE DOCUMENT_DESCRIPTION DOCUMENT_CURRENCY_CODE DOCUMENT_AMOUNT DOCUMENT_DISCOUNT_EARNED DOCUMENT_DISCOUNT_UNEARNED LOCAL_TAX_AMOUNT NATIONAL_TAX_AMOUNT VAT_TAX_AMOUNT DOCUMENT_CURR_CHARGE_AMOUNT SETTLEMENT_AMOUNT BILL_TO_CUSTOMER_ID BILL_TO_ADDRESS_ID BILL_TO_SITE_USE_ID DISCOUNT_AMOUNT FREIGHT_AMOUNT DUTY_AMOUNT PAYMENT_TRXN_EXTENSION_ID LEGAL_ENTITY_ID DOCUMENT_DISPUTED_FLAG SHIP_FROM_ADDRESS_ID SHIP_TO_ADDRESS_ID SPECIAL_INSTRUCTION COLLECTOR_NAME COMMENTS CUSTOMER_REFERENCE BR_DRAWEE_ISSUED_FLAG BR_SIGNED_FLAG TAX_REGISTRATION_NUMBER ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER

Query

SQL_Statement

(SELECT null as PAYMENT_SYSTEM_ORDER_NUMBER, cr.payment_trxn_extension_id, ps.payment_schedule_id, ps.trx_number, trx.purchase_order, null, trx.trx_date, 'INVOICE', null, trx.invoice_currency_code, ps.amount_due_original, ps.discount_taken_earned, ps.discount_taken_unearned, ARP_TRX_LINE_UTIL.get_tax_amount(trx.customer_trx_id, 'SALES_TAX'), null, ARP_TRX_LINE_UTIL.get_tax_amount(trx.customer_trx_id, 'VAT'), null, rec.amount_applied, trx.bill_to_customer_id, trx.bill_to_address_id, trx.bill_to_site_use_id, cr.factor_discount_amount, null, null, trx.payment_trxn_extension_id, trx.legal_entity_id, decode (ps.dispute_date ,NULL,'N','Y'), null, trx.ship_to_address_id, trx.special_instructions, null, trx.comments, null, null, null, reg.registration_number, trx.ATTRIBUTE_CATEGORY, trx.ATTRIBUTE1 , trx.ATTRIBUTE2 , trx.ATTRIBUTE3 , trx.ATTRIBUTE4 , trx.ATTRIBUTE5 , trx.ATTRIBUTE6 , trx.ATTRIBUTE7 , trx.ATTRIBUTE8 , trx.ATTRIBUTE9 , trx.ATTRIBUTE10, trx.ATTRIBUTE11, trx.ATTRIBUTE12 , trx.ATTRIBUTE13 , trx.ATTRIBUTE14 , trx.ATTRIBUTE15, trx.created_by, trx.creation_date, trx.last_updated_by, trx.last_update_date, trx.last_update_login, 1 from ar_cash_receipts cr, ra_customer_trx trx, ar_payment_schedules ps, ar_receipt_classes rc, ar_receipt_methods rm, ar_receivable_applications rec, zx_registrations reg WHERE rec.cash_receipt_id = cr.cash_receipt_id and rec.applied_payment_schedule_id = ps.payment_schedule_id and rec.display = 'Y' and rec.status = 'APP' and cr.receipt_method_id = rm.receipt_method_id and rm.receipt_class_id = rc.receipt_class_id and rc.creation_method_code = 'AUTOMATIC' and cr.type <> 'MISC' and ps.customer_trx_id = trx.customer_trx_id and trx.first_pty_reg_id = reg.registration_id(+))