DBA Data[Home] [Help]

APPS.OKE_DEFAULTING_PKG dependencies on OKE_K_HEADERS

Line 972: from oke_k_lines_v l, okc_k_headers_b h, oke_k_headers k

968: l.copies_required,
969: l.cdrl_category,
970: l.data_item_name,
971: l.export_flag
972: from oke_k_lines_v l, okc_k_headers_b h, oke_k_headers k
973: where h.id = l.header_id
974: and l.k_line_id = p_id
975: and h.id = k.k_header_id;
976:

Line 1196: from oke_k_lines_v l, okc_k_headers_b h, oke_k_headers k

1192: l.copies_required,
1193: l.cdrl_category,
1194: l.data_item_name,
1195: l.export_flag
1196: from oke_k_lines_v l, okc_k_headers_b h, oke_k_headers k
1197: where h.id = p_id
1198: and l.header_id = p_id
1199: and h.id = k.k_header_id
1200: and not exists (select 'x' from oke_k_deliverables_b where k_line_id = l.k_line_id and nvl(defaulted_flag, 'N') = 'Y')

Line 1354: from oke_k_lines_v l, okc_k_headers_b h, oke_k_headers k

1350: l.copies_required,
1351: l.cdrl_category,
1352: l.data_item_name,
1353: l.export_flag
1354: from oke_k_lines_v l, okc_k_headers_b h, oke_k_headers k
1355: where l.k_line_id = p_id
1356: and h.id = l.header_id
1357: and k.k_header_id = l.header_id;
1358: