DBA Data[Home] [Help]

APPS.OKL_UBB_PVT dependencies on OKS_BILL_SUB_LINES_V

Line 152: OKS_BILL_SUB_LINES_V OKS_LNS, OKC_K_HEADERS_B chr,

148: OKS_LNS.DATE_BILLED_TO DATE_BILLED_TO, CNTR.CLG_ID,
149: OKS_LNS.AMOUNT ASSET_AMOUNT, OKS_LNS.ID OKS_DETAIL_ID,
150: chr.contract_number contract_number
151: from okc_k_rel_objs rel, okc_k_lines_v lns, oks_bill_cont_lines_v oks_cont,
152: OKS_BILL_SUB_LINES_V OKS_LNS, OKC_K_HEADERS_B chr,
153: OKC_K_ITEMS ITEMS, OKL_CNTR_LVLNG_LNS_V CNTR, okc_k_lines_v cov_asset
154: where rel.rty_code = 'OKLUBB'
155: and lns.chr_id = rel.object1_id1
156: and lns.id = cov_asset.cle_id

Line 975: OKS_BILL_SUB_LINES_V OKS_LNS, okl_k_lines okll

971: OKS_CONT.AMOUNT line_amount, OKS_CONT.CURRENCY_CODE CURRENCY_CODE,
972: okll.sty_id sty_id
973: from okc_k_rel_objs rel, okl_k_headers hdr, okc_k_headers_b chr, okc_k_lines_b lns,
974: okc_line_styles_b lse, okc_k_lines_b lnsb, OKS_BILL_CONT_LINES_V OKS_CONT,
975: OKS_BILL_SUB_LINES_V OKS_LNS, okl_k_lines okll
976: where rty_code = 'OKLSRV'
977: and rel.jtot_object1_code = 'OKL_COV_PROD'
978: and rel.chr_id = hdr.id
979: and hdr.id = chr.id