DBA Data[Home] [Help]

APPS.OKE_DTS_INTEGRATION_PKG dependencies on OKC_K_LINES_B

Line 633: select id , id , 99999 from okc_k_lines_b ) a

629: from oke_k_deliverables_b d
630: , oke_k_terms kt1
631: , ( select cle_id , cle_id_ascendant , level_sequence from okc_ancestrys
632: union all
633: select id , id , 99999 from okc_k_lines_b ) a
634: where d.deliverable_id = C_deliverable_id
635: and kt1.term_code = C_term_code
636: and kt1.k_header_id = d.k_header_id
637: and a.cle_id = d.k_line_id

Line 1773: , okc_k_lines_b L

1769: , D.description description
1770: , h.authoring_org_id org_id
1771: --bug 7390122 changed oke_k_deliverables_b to oke_k_deliverables_vl as it has description
1772: FROM oke_k_deliverables_vl D
1773: , okc_k_lines_b L
1774: , oke_k_headers_v H
1775: , oke_k_types_vl T
1776: WHERE D.deliverable_id = p_id
1777: AND L.id = D.k_line_id