DBA Data[Home] [Help]

APPS.OKE_DTS_INTEGRATION_PKG dependencies on OKC_K_LINES_B

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

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

Line 1729: , okc_k_lines_b L

1725: , D.description description
1726: , h.authoring_org_id org_id
1727: --bug 7390122 changed oke_k_deliverables_b to oke_k_deliverables_vl as it has description
1728: FROM oke_k_deliverables_vl D
1729: , okc_k_lines_b L
1730: , oke_k_headers_v H
1731: , oke_k_types_vl T
1732: WHERE D.deliverable_id = p_id
1733: AND L.id = D.k_line_id