DBA Data[Home] [Help]

APPS.PO_DOCUMENT_CHECKS_PVT dependencies on OKE_DELIVERABLES_B

Line 9828: -- Look for contract lines in oke_deliverables_b also (DTS flow)

9824: AND pod.oke_contract_line_id NOT IN (SELECT id
9825: FROM okc_k_lines_b
9826: WHERE dnz_chr_id = pol.oke_contract_header_id
9827: --
9828: -- Look for contract lines in oke_deliverables_b also (DTS flow)
9829: UNION
9830: SELECT deliverable_id
9831: FROM oke_deliverables_b
9832: WHERE source_header_id = pol.oke_contract_header_id);

Line 9831: FROM oke_deliverables_b

9827: --
9828: -- Look for contract lines in oke_deliverables_b also (DTS flow)
9829: UNION
9830: SELECT deliverable_id
9831: FROM oke_deliverables_b
9832: WHERE source_header_id = pol.oke_contract_header_id);
9833:
9834: --Increment the p_sequence with number of errors reported in last query
9835: p_sequence := p_sequence + SQL%ROWCOUNT;