APPS.PO_VAL_DISTRIBUTIONS dependencies on PO_LINES_INTERFACE

Line 2032: FROM po_distributions_interface pdi, po_lines_interface pli

2028: FOR i IN 1..p_intf_dist_id_tbl.COUNT LOOP
2029:
2030: SELECT Count(pdi.interface_distribution_id)
2031: INTO l_lines_count
2032: FROM po_distributions_interface pdi, po_lines_interface pli
2033: WHERE pdi.interface_distribution_id = p_intf_dist_id_tbl(i)
2034: AND pdi.interface_line_id = PLI.interface_line_id
2035: AND PLI.group_line_id IS NOT NULL
2036: AND EXISTS ( --distribution against clin

Line 2189: po_lines_interface PLI

2185: SELECT
2186: l_data_key,
2187: pdi.interface_distribution_id
2188: FROM po_distributions_interface pdi,
2189: po_lines_interface PLI
2190: WHERE pdi.interface_distribution_id = p_intf_dist_id_tbl(i)
2191: AND pdi.interface_line_id = PLI.interface_line_id
2192: AND Nvl(PLI.clm_option_indicator,'*') = 'O'
2193: AND Nvl(PLI.clm_exercised_flag,'N') <> 'Y';