APPS.PO_AUTOCREATE_MAINPROC_PVT dependencies on PO_DISTRIBUTIONS_INTERFACE

Line 1220: po_distributions_interface pld

1216: pli.clm_base_line_num ,
1217: PLI.contract_Type ,
1218: pli.receipt_required_flag
1219: FROM po_lines_interface pli,
1220: po_distributions_interface pld
1221: WHERE pli.interface_header_id =x_interface_header_id
1222: AND pli.interface_line_id =pld.interface_line_id
1223: AND pld.interface_distribution_id =
1224: (SELECT MIN(pdi2.interface_distribution_id)

Line 1225: FROM po_distributions_interface pdi2

1221: WHERE pli.interface_header_id =x_interface_header_id
1222: AND pli.interface_line_id =pld.interface_line_id
1223: AND pld.interface_distribution_id =
1224: (SELECT MIN(pdi2.interface_distribution_id)
1225: FROM po_distributions_interface pdi2
1226: WHERE pdi2.interface_line_id = pli.interface_line_id
1227: )
1228:
1229: UNION

Line 1274: FROM po_distributions_interface pdi2

1270: FROM po_lines_interface pli
1271: WHERE pli.interface_header_id=x_interface_header_id
1272: AND NOT EXISTS
1273: (SELECT 'x'
1274: FROM po_distributions_interface pdi2
1275: WHERE pdi2.interface_line_id = pli.interface_line_id
1276: )
1277: ORDER BY 4, --pli.item_id,
1278: 5, --pli.item_description,

Line 2367: DESC: Handle the logic to derive, default, validate records from po_distributions_interface

2363: END process_line_locations;
2364:
2365: /* ============================================================================
2366: NAME: process_distributions
2367: DESC: Handle the logic to derive, default, validate records from po_distributions_interface
2368: table and insert records into po_distributions_draft_all table.
2369: PO_AUTO_DIST_PROCESS_PVT.fetch_dists
2370: PO_AUTO_DIST_PROCESS_PVT.derive_and_default_dists
2371: PO_AUTO_LINE_LOC_PROCESS_PVT.validate_dists (??)