DBA Data[Home] [Help]

APPS.PO_VAL_DISTRIBUTIONS dependencies on PO_DISTRIBUTIONS_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 2038: FROM po_distributions_interface

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
2037: SELECT interface_distribution_id
2038: FROM po_distributions_interface
2039: WHERE interface_line_id = PLI.group_line_id
2040: );
2041: IF l_lines_count > 0 THEN
2042: x_results.add_result(

Line 2188: FROM po_distributions_interface pdi,

2184: num1)
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'