DBA Data[Home] [Help]

APPS.OKL_UBB_PVT dependencies on HZ_CUST_ACCOUNTS

Line 181: hz_cust_accounts hca

177: iex_wf_ban_status_pub.get_turninvoff(hca.party_id,hca.cust_account_id,SYSDATE) bankruptcy_sts
178: from okc_k_rel_objs rel, okc_k_lines_v lns, oks_bill_cont_lines_v oks_cont,
179: OKS_BILL_SUB_LINES_V OKS_LNS, OKC_K_HEADERS_B chr,
180: OKC_K_ITEMS ITEMS, OKL_CNTR_LVLNG_LNS_V CNTR, okc_k_lines_v cov_asset,
181: hz_cust_accounts hca
182: where rel.rty_code = 'OKLUBB'
183: and chr.cust_acct_id = hca.cust_account_id
184: and hca.status = 'A'
185: and lns.chr_id = rel.object1_id1