APPS.WIP_OSP_SHP_I_WF dependencies on PO_HEADERS_ALL

Line 594: from po_headers_all ph,

590: round(pd.quantity_ordered,
591: WIP_CONSTANTS.INV_MAX_PRECISION),
592: round(wo.scheduled_quantity,
593: WIP_CONSTANTS.INV_MAX_PRECISION))) required_assy_qty
594: from po_headers_all ph,
595: po_lines_all pl,
596: po_distributions_all pd,
597: po_vendors pv,
598: po_vendor_sites_all pvs,

Line 656: po_headers_all ph,

652: WIP_CONSTANTS.INV_MAX_PRECISION),
653: round(wo.scheduled_quantity,
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,

Line 1127: from po_headers_all ph,

1123: pvs.address_line1, pvs.address_line2, pvs.address_line3,
1124: pvs.address_line4, pvs.city,pvs.county,pvs.state,
1125: pvs.province,pvs.zip,null)
1126: into l_address
1127: from po_headers_all ph,
1128: po_vendor_sites_all pvs
1129: where ph.po_header_id = l_po_header_id
1130: and pvs.org_id = ph.org_id
1131: and pvs.vendor_site_id = ph.vendor_site_id;

Line 1219: po_headers_all ph,

1215: pr.release_num
1216: from po_releases_all pr,
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

Line 1442: po_headers_all ph2,

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
1446: where pd1.po_distribution_id = l_po_distribution_id