APPS.WIP_OSP_SHP_I_WF dependencies on PO_LINE_LOCATIONS_ALL

Line 615: po_line_locations_all ps,

611: WIP_CONSTANTS.INV_MAX_PRECISION))) required_assy_qty
612: from po_releases_all pr,
613: po_headers_all ph,
614: po_lines_all pl,
615: po_line_locations_all ps,
616: po_distributions_all pd,
617: po_vendors pv,
618: po_vendor_sites_all pvs,
619: wip_operation_resources wor,

Line 1158: po_line_locations_all ps

1154: pd.wip_repetitive_schedule_id,
1155: ps.ship_to_organization_id,
1156: pd.wip_operation_seq_num
1157: from po_distributions_all pd,
1158: po_line_locations_all ps
1159: where pd.po_distribution_id = p_po_distribution_id
1160: and ps.line_location_id = pd.line_location_id;
1161:
1162: cursor GetPOData (p_po_distribution_id NUMBER) is

Line 1178: po_line_locations_all ps,

1174: po_vendor_sites_all pvs,
1175: po_vendors pv,
1176: po_headers_all ph,
1177: po_lines_all pl,
1178: po_line_locations_all ps,
1179: po_distributions_all pd
1180: where pd.po_distribution_id = p_po_distribution_id
1181: and ps.line_location_id = pd.line_location_id
1182: and pl.po_line_id = pd.po_line_id

Line 1398: po_line_locations_all ps1,

1394: from po_releases_all pr,
1395: po_location_associations_all pla,
1396: mtl_system_items_kfv msik2,
1397: po_lines_all pl2,
1398: po_line_locations_all ps1,
1399: po_headers_all ph2,
1400: wip_operations wo,
1401: po_distributions_all pd2,
1402: po_distributions_all pd1

Line 1439: po_line_locations_all ps

1435: from po_vendors pv,
1436: po_vendor_sites_all pvs,
1437: po_distributions_all pd,
1438: po_location_associations pla,
1439: po_line_locations_all ps
1440: where pd.po_distribution_id = l_po_distribution_id
1441: and ps.line_location_id = pd.line_location_id
1442: and pla.location_id = ps.ship_to_location_id
1443: and pv.vendor_id = pla.vendor_id