DBA Data[Home] [Help]

APPS.OKL_STREAM_BILLING_PVT dependencies on OKC_K_ITEMS

Line 1370: , okc_k_items item

1366: UNION
1367: SELECT cs.cust_acct_site_id, cp.standard_terms payment_term_id
1368: FROM okc_k_headers_b khr
1369: , okc_k_lines_b cle
1370: , okc_k_items item
1371: , okc_k_lines_b linked_asset
1372: , okx_cust_site_uses_v cs
1373: , hz_customer_profiles cp
1374: WHERE khr.id = p_khr_id

Line 1406: , okc_k_items_v item

1402: rgp.dnz_chr_id = p_khr_id
1403: UNION
1404: SELECT rul.object1_id1
1405: FROM okc_k_lines_b cle
1406: , okc_k_items_v item
1407: , okc_k_lines_b linked_asset
1408: , OKC_RULES_B rul
1409: , Okc_rule_groups_B rgp
1410: WHERE cle.dnz_chr_id = p_khr_id AND

Line 1457: , okc_k_items_v item

1453: rgp.dnz_chr_id = p_khr_id
1454: UNION
1455: SELECT rul.object1_id1
1456: FROM okc_k_lines_b cle
1457: , okc_k_items_v item
1458: , okc_k_lines_b linked_asset
1459: , OKC_RULES_B rul
1460: , Okc_rule_groups_B rgp
1461: WHERE cle.dnz_chr_id = p_khr_id AND