APPS.ARRX_BRS dependencies on AR_LOOKUPS

Line 90: v_status AR_LOOKUPS.meaning%TYPE;

86: v_CursorID_asg INTEGER;
87: v_Dummy_asg INTEGER;
88:
89: -- Declare the variables which will hold the results of the SELECT statements
90: v_status AR_LOOKUPS.meaning%TYPE;
91: v_status_date AR_TRANSACTION_HISTORY.trx_date%TYPE;
92: v_customer_trx_id RA_CUSTOMER_TRX.customer_trx_id%TYPE;
93: v_transaction_number RA_CUSTOMER_TRX.trx_number%TYPE;
94: v_document_number RA_CUSTOMER_TRX.doc_sequence_value%TYPE;

Line 111: v_drawee_class AR_LOOKUPS.meaning%TYPE;

107: v_drawee_city HZ_LOCATIONS.city%TYPE;
108: v_drawee_state HZ_LOCATIONS.state%TYPE;
109: v_drawee_country HZ_LOCATIONS.country%TYPE;
110: v_drawee_postal_code HZ_LOCATIONS.postal_code%TYPE;
111: v_drawee_class AR_LOOKUPS.meaning%TYPE;
112: v_drawee_category AR_LOOKUPS.meaning%TYPE;
113: v_drawee_location HZ_CUST_SITE_USES.location%TYPE;
114: v_issue_date RA_CUSTOMER_TRX.trx_date%TYPE;
115: v_status_gl_date AR_TRANSACTION_HISTORY.gl_date%TYPE;

Line 112: v_drawee_category AR_LOOKUPS.meaning%TYPE;

108: v_drawee_state HZ_LOCATIONS.state%TYPE;
109: v_drawee_country HZ_LOCATIONS.country%TYPE;
110: v_drawee_postal_code HZ_LOCATIONS.postal_code%TYPE;
111: v_drawee_class AR_LOOKUPS.meaning%TYPE;
112: v_drawee_category AR_LOOKUPS.meaning%TYPE;
113: v_drawee_location HZ_CUST_SITE_USES.location%TYPE;
114: v_issue_date RA_CUSTOMER_TRX.trx_date%TYPE;
115: v_status_gl_date AR_TRANSACTION_HISTORY.gl_date%TYPE;
116: v_maturity_date RA_CUSTOMER_TRX.term_due_date%TYPE;

Line 159: v_unpaid_receipt_rev_reason AR_LOOKUPS.meaning%TYPE;

155: v_remittance_batch_name AR_BATCHES.name%TYPE;
156: v_remittance_method AR_BATCHES.remit_method_code%TYPE;
157: v_with_recourse AR_BATCHES.with_recourse_flag%TYPE;
158: v_last_printed_date RA_CUSTOMER_TRX.printing_last_printed%TYPE;
159: v_unpaid_receipt_rev_reason AR_LOOKUPS.meaning%TYPE;
160: v_risk_elimination_days AR_RECEIPT_METHOD_ACCOUNTS.risk_elimination_days%TYPE;
161: v_remittance_date AR_TRANSACTION_HISTORY.trx_date%TYPE;
162: v_remittance_payment_method AR_RECEIPT_METHODS.name%TYPE;
163: v_creation_batch_name RA_BATCHES.name%TYPE;

Line 240: ar_lookups arl

236: rah.trx_date,
237: rah.gl_date,
238: rah.status
239: FROM ar_transaction_history_all rah,
240: ar_lookups arl
241: WHERE arl.lookup_code = rah.status '||
242: l_org_where_rah ||
243: 'AND arl.lookup_type = ''TRANSACTION_HISTORY_STATUS'''||
244: 'AND rah.transaction_history_id = (SELECT MAX(rah1.transaction_history_id)

Line 311: ar_lookups arl

307: l_receipt_reversal := 'SELECT distinct DECODE(cr.reversal_reason_code, NULL, NULL
308: , initcap(arl.meaning))
309: FROM ar_cash_receipts_all cr,
310: ar_receivable_applications_all app,
311: ar_lookups arl
312: WHERE cr.cash_receipt_id = app.cash_receipt_id '||
313: l_org_where_app ||
314: l_org_where_cr ||
315: 'AND cr.reversal_reason_code = arl.lookup_code (+)

Line 496: ,ar_lookups arl

492: ,hz_parties party
493: ,ce_bank_branches_v rabb
494: ,ce_bank_accounts cba
495: ,ce_bank_acct_uses raba
496: ,ar_lookups arl
497: ,ar_lookups arl_class
498: ,ar_lookups arl_category
499: ,ar_transaction_history_all rah
500: ,fnd_document_sequences fds

Line 497: ,ar_lookups arl_class

493: ,ce_bank_branches_v rabb
494: ,ce_bank_accounts cba
495: ,ce_bank_acct_uses raba
496: ,ar_lookups arl
497: ,ar_lookups arl_class
498: ,ar_lookups arl_category
499: ,ar_transaction_history_all rah
500: ,fnd_document_sequences fds
501: ,ar_payment_schedules_all ps

Line 498: ,ar_lookups arl_category

494: ,ce_bank_accounts cba
495: ,ce_bank_acct_uses raba
496: ,ar_lookups arl
497: ,ar_lookups arl_class
498: ,ar_lookups arl_category
499: ,ar_transaction_history_all rah
500: ,fnd_document_sequences fds
501: ,ar_payment_schedules_all ps
502: ,ra_batches_all rab