[Home] [Help]
2601: FROM ar_receivable_applications_all ara,
2602: ar_cash_receipts_all acr,
2603: hz_cust_site_uses_all hcsu,
2604: hz_cust_acct_sites_all hcas,
2605: hz_cust_accounts hca
2606: WHERE ara.receivable_application_id = l_ar_source_id
2607: AND ara.cash_receipt_id = acr.cash_receipt_id
2608: AND hcsu.site_use_id = acr.customer_site_use_id
2609: AND hcas.cust_acct_site_id = hcsu.cust_acct_site_id
2631: FROM ar_cash_receipt_history_all ara,
2632: ar_cash_receipts_all acr,
2633: hz_cust_site_uses_all hcsu,
2634: hz_cust_acct_sites_all hcas,
2635: hz_cust_accounts hca
2636: WHERE ara.cash_receipt_history_id = l_ar_source_id
2637: AND ara.cash_receipt_id = acr.cash_receipt_id
2638: AND hcsu.site_use_id = acr.customer_site_use_id
2639: AND hcas.cust_acct_site_id = hcsu.cust_acct_site_id
2661: FROM ar_adjustments_all ara,
2662: ar_cash_receipts_all acr,
2663: hz_cust_site_uses_all hcsu,
2664: hz_cust_acct_sites_all hcas,
2665: hz_cust_accounts hca
2666: WHERE ara.adjustment_id = l_ar_source_id
2667: AND ara.associated_cash_receipt_id = acr.cash_receipt_id
2668: AND hcsu.site_use_id = acr.customer_site_use_id
2669: AND hcas.cust_acct_site_id = hcsu.cust_acct_site_id
2688: FROM ar_misc_cash_distributions_all ara,
2689: ar_cash_receipts_all acr,
2690: hz_cust_site_uses_all hcsu,
2691: hz_cust_acct_sites_all hcas,
2692: hz_cust_accounts hca
2693: WHERE ara.misc_cash_distribution_id = l_ar_source_id
2694: AND ara.cash_receipt_id = acr.cash_receipt_id
2695: AND hcsu.site_use_id = acr.customer_site_use_id
2696: AND hcas.cust_acct_site_id = hcsu.cust_acct_site_id
3019: log(l_module,'12.2 or above, using dynamic select');
3020: l_select := ' SELECT cust_account_id,
3021: NVL(federal_entity_type,''N''),
3022: SUBSTR(trading_partner_agency_id,1,3)
3023: FROM hz_cust_accounts_all
3024: WHERE cust_account_id = :party_id';
3025: EXECUTE IMMEDIATE l_select
3026: INTO l_vendor_id,
3027: l_vendor_type,
3044: 'ATTRIBUTE14', C.ATTRIBUTE14, 'ATTRIBUTE15', C.ATTRIBUTE15) eliminations_id
3045: INTO l_vendor_id,
3046: l_vendor_type,
3047: l_eliminations_id
3048: FROM hz_cust_accounts_all c
3049: WHERE c.cust_account_id = to_number(l_reference_7);
3050: END IF;
3051: ELSE
3052: log(l_module,' REFERENCE_7 I.E. '|| 'customer_id is NULL');
3099: --SELECT dept_id||main_account
3100: --FROM fv_be_trx_dtls
3101: --WHERE transaction_id = to_number(l_reference_1);
3102: l_doc_number fv_be_trx_hdrs.doc_number%TYPE;
3103: l_cust_class_code hz_cust_accounts_all.customer_class_code%TYPE;
3104: BEGIN
3105:
3106: log(l_module,'BUDGETARY TRANSACTION');
3107:
3119: --Added for bug 7256357
3120: SELECT hzca.customer_class_code
3121: INTO l_cust_class_code
3122: FROM ra_customer_trx rct,
3123: hz_cust_accounts hzca
3124: WHERE rct.trx_number = l_doc_number
3125: AND rct.set_of_books_id = g_set_of_books_id
3126: AND hzca.cust_account_id = rct.bill_to_customer_id;
3127:
5110:
5111: SELECT hzca.customer_class_code
5112: INTO l_cust_class_code
5113: FROM ra_customer_trx_all rct,
5114: hz_cust_accounts_all hzca
5115: WHERE rct.trx_number = p_reimb_agree_seg_val
5116: AND rct.set_of_books_id = g_set_of_books_id
5117: AND hzca.cust_account_id = rct.bill_to_customer_id;
5118:
5152:
5153: SELECT hzca.customer_class_code
5154: INTO l_cust_class_code
5155: FROM ra_customer_trx_all rct,
5156: hz_cust_accounts_all hzca
5157: WHERE rct.trx_number = p_reimb_agree_seg_val
5158: AND rct.set_of_books_id = g_set_of_books_id
5159: AND hzca.cust_account_id = rct.bill_to_customer_id;
5160:
5682: BEGIN
5683: log(l_module, 'Begin: ');
5684:
5685: --For 12.2 and above we have to use columns
5686: --hz_cust_accounts.federal_entity_type, trading_partner_agency_id
5687: --For 12.1 and below we have to use class code and dffs.
5688: --Check if the new columns exist, if not use the dffs.
5689: BEGIN
5690:
5695:
5696: SELECT 'Y'
5697: INTO g_cust_col_exists
5698: FROM all_tab_columns
5699: WHERE table_name = 'HZ_CUST_ACCOUNTS'
5700: AND owner = l_ar_schema
5701: AND column_name = 'FEDERAL_ENTITY_TYPE';
5702: log(l_module, 'g_cust_col_exists: '||g_cust_col_exists);
5703: