DBA Data[Home] [Help]

APPS.PO_DOCUMENT_CHECKS_PVT dependencies on PO_LINES_ALL_EXT_B

Line 1689: po_lines_all_ext_b ple,

1685: 'PO_PRICING_MISMATCH',
1686: 'E',
1687: pol.line_num
1688: FROM po_lines_gt pol,
1689: po_lines_all_ext_b ple,
1690: po_uda_ag_template_usages ptu
1691: WHERE ple.po_line_id = pol.po_line_id
1692: AND ple.draft_id = p_draft_id
1693: AND ple.attr_group_id = ptu.attribute_group_id

Line 1743: po_lines_all_ext_b ple

1739: FROM po_lines_gt pol
1740: WHERE pol.order_type_lookup_code <> 'QUANTITY'
1741: AND NOT EXISTS ( Select 1
1742: FROM po_uda_ag_template_usages ptu,
1743: po_lines_all_ext_b ple
1744: WHERE ptu.attribute_category = 'PRICING'
1745: AND ptu.attribute2 = pol.contract_type
1746: AND ptu.attribute1 = pol.clm_idc_type
1747: AND ptu.template_id = ple.uda_template_id