APPS.WIP_OSP_SHP_I_WF dependencies on PO_LINE_LOCATIONS_ALL

Line 658: po_line_locations_all ps,

654: WIP_CONSTANTS.INV_MAX_PRECISION))) required_assy_qty
655: from po_releases_all pr,
656: po_headers_all ph,
657: po_lines_all pl,
658: po_line_locations_all ps,
659: po_distributions_all pd,
660: po_vendors pv,
661: po_vendor_sites_all pvs,
662: wip_operation_resources wor,

Line 1201: po_line_locations_all ps

1197: pd.wip_repetitive_schedule_id,
1198: ps.ship_to_organization_id,
1199: pd.wip_operation_seq_num
1200: from po_distributions_all pd,
1201: po_line_locations_all ps
1202: where pd.po_distribution_id = p_po_distribution_id
1203: and ps.line_location_id = pd.line_location_id;
1204:
1205: cursor GetPOData (p_po_distribution_id NUMBER) is

Line 1221: po_line_locations_all ps,

1217: po_vendor_sites_all pvs,
1218: po_vendors pv,
1219: po_headers_all ph,
1220: po_lines_all pl,
1221: po_line_locations_all ps,
1222: po_distributions_all pd
1223: where pd.po_distribution_id = p_po_distribution_id
1224: and ps.line_location_id = pd.line_location_id
1225: and pl.po_line_id = pd.po_line_id

Line 1441: po_line_locations_all ps1,

1437: from po_releases_all pr,
1438: po_location_associations_all pla,
1439: mtl_system_items_kfv msik2,
1440: po_lines_all pl2,
1441: po_line_locations_all ps1,
1442: po_headers_all ph2,
1443: wip_operations wo,
1444: po_distributions_all pd2,
1445: po_distributions_all pd1

Line 1482: po_line_locations_all ps

1478: from po_vendors pv,
1479: po_vendor_sites_all pvs,
1480: po_distributions_all pd,
1481: po_location_associations pla,
1482: po_line_locations_all ps
1483: where pd.po_distribution_id = l_po_distribution_id
1484: and ps.line_location_id = pd.line_location_id
1485: and pla.location_id = ps.ship_to_location_id
1486: and pv.vendor_id = pla.vendor_id