APPS.IGIRCABJP dependencies on HZ_PARTIES

Line 89: hz_parties, -- Bug 3902175

85: FROM
86: ra_customer_trx_all ct,
87: ra_cust_trx_types_all ctt,
88: ar_distributions_all ard,
89: hz_parties, -- Bug 3902175
90: hz_cust_accounts, -- Bug 3902175
91: ar_adjustments_all adj,
92: ar_lookups l_cat,
93: xla_ae_headers xah

Line 103: and hz_parties.party_id = hz_cust_accounts.party_id -- Bug 3902175

99: and ard.source_table = 'ADJ'
100: and adj.customer_trx_id = ct.customer_trx_id
101: and ctt.cust_trx_type_id = ct.cust_trx_type_id
102: and hz_cust_accounts.cust_account_id = ct.bill_to_customer_id -- Bug 3902175
103: and hz_parties.party_id = hz_cust_accounts.party_id -- Bug 3902175
104: and l_cat.lookup_type = 'ARRGTA_FUNCTION_MAPPING'
105: and l_cat.lookup_code = 'ADJ_' || ard.source_type
106: and ct.invoice_currency_code = decode( p_Report.FuncCurr,
107: null,ct.invoice_currency_code,

Line 259: hz_parties, -- Bug 3902175

255: 'RA_CUST_TRX_LINE_GL_DIST' ref30
256: FROM
257: ar_lookups l_cat,
258: ra_cust_trx_types ctt,
259: hz_parties, -- Bug 3902175
260: hz_cust_accounts, -- Bug 3902175
261: ra_customer_trx_all ct,
262: ra_cust_trx_line_gl_dist ctlgd,
263: xla_ae_headers xah

Line 271: and hz_parties.party_id = hz_cust_accounts.party_id -- Bug 3902175

267: and ctlgd.account_set_flag = 'N'
268: and ctlgd.customer_trx_id = ct.customer_trx_id
269: and ct.complete_flag = 'Y'
270: and ct.cust_trx_type_id = ctt.cust_trx_type_id
271: and hz_parties.party_id = hz_cust_accounts.party_id -- Bug 3902175
272: and hz_cust_accounts.cust_account_id = ct.bill_to_customer_id -- Bug 3902175
273: and l_cat.lookup_type = 'ARRGTA_FUNCTION_MAPPING'
274: and l_cat.lookup_code = decode(ctt.type,
275: 'CM', 'CM_',

Line 435: from hz_parties,hz_cust_accounts where hz_parties.party_id = hz_cust_accounts.party_id) cust, -- bug 3902175

431: 'AR_CASH_RECEIPT_HISTORY' ref30
432: FROM
433: ar_lookups l_cat,
434: (Select hz_cust_accounts.account_number customer_number,hz_cust_accounts.cust_account_id customer_id
435: from hz_parties,hz_cust_accounts where hz_parties.party_id = hz_cust_accounts.party_id) cust, -- bug 3902175
436: ar_distributions ard,
437: ar_cash_receipts cr,
438: ar_cash_receipt_history_all crh,
439: xla_ae_headers xah

Line 596: from hz_parties,hz_cust_accounts where hz_parties.party_id = hz_cust_accounts.party_id) cust, -- bug 3902175

592: ar_posting_control pc,
593: ar_system_parameters sp,
594: gl_sets_of_books gl,
595: (Select hz_cust_accounts.account_number customer_number,hz_cust_accounts.cust_account_id customer_id
596: from hz_parties,hz_cust_accounts where hz_parties.party_id = hz_cust_accounts.party_id) cust, -- bug 3902175
597: xla_ae_headers xah
598: WHERE
599: ra.receivable_application_id+0 < p_Report.NxtReceivableApplicationId
600: and ard.source_table = 'RA'

Line 700: hz_parties,

696: ar_lookups l_cat,
697: ar_posting_control pc,
698: ar_system_parameters sp,
699: gl_sets_of_books gl,
700: hz_parties,
701: hz_cust_accounts,
702: xla_ae_headers xah
703: WHERE
704: ra.receivable_application_id+0 < p_Report.NxtReceivableApplicationId

Line 715: and hz_parties.party_id = hz_cust_accounts.party_id -- Bug 3902175

711: and ra.customer_trx_id = ctlgdcm.customer_trx_id
712: and ctlgdcm.account_class = 'REC'
713: and ctlgdcm.latest_rec_flag = 'Y'
714: and ra.applied_customer_trx_id = ctinv.customer_trx_id
715: and hz_parties.party_id = hz_cust_accounts.party_id -- Bug 3902175
716: and hz_cust_accounts.cust_account_id = ctcm.bill_to_customer_id -- Bug 3902175
717: and l_cat.lookup_type = 'ARRGTA_FUNCTION_MAPPING'
718: and l_cat.lookup_code = 'CMAPP_' || ard.source_type
719: and sp.set_of_books_id = p_Report.SetOfBooksId