APPS.WIP_OSP_SHP_I_WF dependencies on PO_VENDORS

Line 554: po_vendors pv,

550: WIP_CONSTANTS.INV_MAX_PRECISION))) required_assy_qty
551: from po_headers_all ph,
552: po_lines_all pl,
553: po_distributions_all pd,
554: po_vendors pv,
555: po_vendor_sites_all pvs,
556: wip_operation_resources wor,
557: wip_operations wo,
558: mtl_system_items msi

Line 617: po_vendors pv,

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,
620: wip_operations wo,
621: mtl_system_items msi

Line 678: l_subcontractor_name PO_VENDORS.VENDOR_NAME%TYPE;

674: l_org_id NUMBER;
675: l_po_number VARCHAR2(80);
676: l_po_line_qty NUMBER;
677: l_po_line_uom VARCHAR2(25);
678: l_subcontractor_name PO_VENDORS.VENDOR_NAME%TYPE;
679: l_subcontractor_site VARCHAR2(80);
680: l_primary_qty NUMBER;
681: msg VARCHAR2(2000);
682: l_non_approved_pos VARCHAR2(2000) := '';

Line 899: l_subcontractor PO_VENDORS.VENDOR_NAME%TYPE;

895: l_primary_qty NUMBER;
896: l_primary_uom VARCHAR2(10);
897: l_rep_sched_id NUMBER;
898: l_ship_qty NUMBER;
899: l_subcontractor PO_VENDORS.VENDOR_NAME%TYPE;
900: l_subcontractor_site VARCHAR2(80);
901: l_wip_entity_id NUMBER;
902: l_user_id NUMBER;
903: l_resp_id NUMBER;

Line 1148: l_subcontractor_name PO_VENDORS.VENDOR_NAME%TYPE;

1144: l_org_id NUMBER;
1145: l_po_number VARCHAR2(80);
1146: l_po_line_qty NUMBER;
1147: l_po_line_uom VARCHAR2(25);
1148: l_subcontractor_name PO_VENDORS.VENDOR_NAME%TYPE;
1149: l_subcontractor_site VARCHAR2(80);
1150: l_release_num NUMBER ;
1151:
1152: cursor GetWIPData (p_po_distribution_id NUMBER) is

Line 1175: po_vendors pv,

1171: ps.ship_to_location_id ship_to_location_id,
1172: pr.release_num
1173: from po_releases_all pr,
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

Line 1435: from po_vendors pv,

1431:
1432: cursor GetShipToData (l_po_distribution_id NUMBER) is
1433: select pv.vendor_name,
1434: pvs.vendor_site_code
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

Line 1455: l_subcontractor_name PO_VENDORS.VENDOR_NAME%TYPE;

1451: l_org_id NUMBER;
1452: l_po_number VARCHAR2(80);
1453: l_po_line_qty NUMBER;
1454: l_po_line_uom VARCHAR2(25);
1455: l_subcontractor_name PO_VENDORS.VENDOR_NAME%TYPE;
1456: l_subcontractor_site VARCHAR2(80);
1457:
1458: l_next_op_seq NUMBER;
1459: l_osp_item_id NUMBER;