DBA Data[Home] [Help]

APPS.PO_DOCUMENT_CHECKS_PVT dependencies on OKE_DELIVERABLES_B

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

7155: AND pod.oke_contract_line_id NOT IN (SELECT id
7156: FROM okc_k_lines_b
7157: WHERE dnz_chr_id = pol.oke_contract_header_id
7158: --
7159: -- Look for contract lines in oke_deliverables_b also (DTS flow)
7160: UNION
7161: SELECT deliverable_id
7162: FROM oke_deliverables_b
7163: WHERE source_header_id = pol.oke_contract_header_id);

Line 7162: FROM oke_deliverables_b

7158: --
7159: -- Look for contract lines in oke_deliverables_b also (DTS flow)
7160: UNION
7161: SELECT deliverable_id
7162: FROM oke_deliverables_b
7163: WHERE source_header_id = pol.oke_contract_header_id);
7164:
7165: --Increment the p_sequence with number of errors reported in last query
7166: p_sequence := p_sequence + SQL%ROWCOUNT;