APPS.JMF_SUBCONTRACT_ORDERS_PVT dependencies on MTL_SYSTEM_ITEMS

Line 425: FROM mtl_system_items_b

421: SELECT lot_control_code,
422: serial_number_control_code
423: INTO l_lot_control_code,
424: l_serial_control_code
425: FROM mtl_system_items_b
426: WHERE inventory_item_id = p_item_id
427: AND organization_id = p_organization_id;
428:
429: IF l_lot_control_code <> 1 OR l_serial_control_code <> 1

Line 1640: mtl_system_items_b msib

1636: po_line_locations_all plla,
1637: po_lines_all pla,
1638: po_headers_all pha,
1639: mtl_interorg_parameters mip,
1640: mtl_system_items_b msib
1641: WHERE hoi.org_information_context = 'Customer/Supplier Association'
1642: AND TO_NUMBER(hoi.org_information3) = pha.vendor_id
1643: AND TO_NUMBER(hoi.org_information4) = pha.vendor_site_id
1644: AND mip.to_organization_id = plla.ship_to_organization_id

Line 1943: FROM mtl_system_items

1939: WHERE line_id = l_order_line_id;
1940:
1941: SELECT primary_uom_code
1942: INTO l_primary_uom
1943: FROM mtl_system_items
1944: WHERE inventory_item_id = l_component_id
1945: AND organization_id = l_tp_organization_id;
1946:
1947: l_ordered_uom:= JMF_SHIKYU_UTIL.Get_UOM_Code(l_po_uom);

Line 3142: l_osa_item MTL_SYSTEM_ITEMS_B.SEGMENT1%TYPE;

3138: l_po_qty NUMBER;
3139: l_comp_qty NUMBER;
3140: l_msg_data VARCHAR2(2000);
3141: l_msg_count NUMBER;
3142: l_osa_item MTL_SYSTEM_ITEMS_B.SEGMENT1%TYPE;
3143: l_tp_organization MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;
3144: l_message VARCHAR(2000);
3145: l_status_flag BOOLEAN;
3146:

Line 3317: FROM mtl_system_items_b

3313: /* Log the error in the Concurrent Request log */
3314: BEGIN
3315:
3316: SELECT segment1 INTO l_osa_item
3317: FROM mtl_system_items_b
3318: WHERE inventory_item_id = l_osa_tbl(i).osa_item_id
3319: AND organization_id = l_osa_tbl(i).tp_organization_id ;
3320:
3321: SELECT organization_code INTO l_tp_organization