APPS.WIP_OSP_SHP_I_WF dependencies on PO_VENDORS

Line 597: po_vendors pv,

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,
599: wip_operation_resources wor,
600: wip_operations wo,
601: mtl_system_items msi

Line 660: po_vendors pv,

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,
663: wip_operations wo,
664: mtl_system_items msi

Line 721: l_subcontractor_name PO_VENDORS.VENDOR_NAME%TYPE;

717: l_org_id NUMBER;
718: l_po_number VARCHAR2(80);
719: l_po_line_qty NUMBER;
720: l_po_line_uom VARCHAR2(25);
721: l_subcontractor_name PO_VENDORS.VENDOR_NAME%TYPE;
722: l_subcontractor_site VARCHAR2(80);
723: l_primary_qty NUMBER;
724: msg VARCHAR2(2000);
725: l_non_approved_pos VARCHAR2(2000) := '';

Line 942: l_subcontractor PO_VENDORS.VENDOR_NAME%TYPE;

938: l_primary_qty NUMBER;
939: l_primary_uom VARCHAR2(10);
940: l_rep_sched_id NUMBER;
941: l_ship_qty NUMBER;
942: l_subcontractor PO_VENDORS.VENDOR_NAME%TYPE;
943: l_subcontractor_site VARCHAR2(80);
944: l_wip_entity_id NUMBER;
945: l_user_id NUMBER;
946: l_resp_id NUMBER;

Line 1191: l_subcontractor_name PO_VENDORS.VENDOR_NAME%TYPE;

1187: l_org_id NUMBER;
1188: l_po_number VARCHAR2(80);
1189: l_po_line_qty NUMBER;
1190: l_po_line_uom VARCHAR2(25);
1191: l_subcontractor_name PO_VENDORS.VENDOR_NAME%TYPE;
1192: l_subcontractor_site VARCHAR2(80);
1193: l_release_num NUMBER ;
1194:
1195: cursor GetWIPData (p_po_distribution_id NUMBER) is

Line 1218: po_vendors pv,

1214: ps.ship_to_location_id ship_to_location_id,
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

Line 1478: from po_vendors pv,

1474:
1475: cursor GetShipToData (l_po_distribution_id NUMBER) is
1476: select pv.vendor_name,
1477: pvs.vendor_site_code
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

Line 1498: l_subcontractor_name PO_VENDORS.VENDOR_NAME%TYPE;

1494: l_org_id NUMBER;
1495: l_po_number VARCHAR2(80);
1496: l_po_line_qty NUMBER;
1497: l_po_line_uom VARCHAR2(25);
1498: l_subcontractor_name PO_VENDORS.VENDOR_NAME%TYPE;
1499: l_subcontractor_site VARCHAR2(80);
1500:
1501: l_next_op_seq NUMBER;
1502: l_osp_item_id NUMBER;