DBA Data[Home] [Help]

APPS.WMS_CONTAINER_PVT dependencies on MTL_SYSTEM_ITEMS

Line 1707: , mtl_system_items msi

1703: , msi.lot_control_code
1704: , msi.revision_qty_control_code
1705: FROM wms_license_plate_numbers wlpn
1706: , wms_lpn_contents wlc
1707: , mtl_system_items msi
1708: WHERE wlpn.organization_id = p_old_org_id
1709: AND wlpn.outermost_lpn_id = p_outermost_lpn_id
1710: AND wlc.parent_lpn_id = wlpn.lpn_id
1711: AND msi.inventory_item_id = wlc.inventory_item_id

Line 5304: FROM mtl_system_items

5300: SELECT unit_weight
5301: , weight_uom_code
5302: INTO l_lpn_tbl(l_tmp_i).tare_weight
5303: , l_lpn_tbl(l_tmp_i).tare_weight_uom_code
5304: FROM mtl_system_items
5305: WHERE organization_id = l_child_lpn.organization_id
5306: AND inventory_item_id = l_child_lpn.inventory_item_id;
5307: ELSE
5308: -- if there isn't a container item, empty lpns will have undefined

Line 5389: FROM mtl_system_items

5385: SELECT unit_weight
5386: , weight_uom_code
5387: INTO l_lpn_tbl(l_tmp_i).tare_weight
5388: , l_lpn_tbl(l_tmp_i).tare_weight_uom_code
5389: FROM mtl_system_items
5390: WHERE organization_id = empty_lpn_rec.organization_id
5391: AND inventory_item_id = empty_lpn_rec.inventory_item_id;
5392: ELSE
5393: -- if there isn't a container item, empty lpns will have undefined

Line 6141: FROM MTL_SYSTEM_ITEMS

6137: WHERE master_organization_id = p_organization_id
6138: AND load_item_id = p_source_item_id
6139: AND container_item_id IN
6140: (SELECT inventory_item_id
6141: FROM MTL_SYSTEM_ITEMS
6142: WHERE mtl_transactions_enabled_flag = 'Y'
6143: AND container_item_flag = 'Y'
6144: AND organization_id = p_organization_id);
6145:

Line 6706: FROM mtl_system_items

6702:
6703: -- Find primary UOM for this item
6704: SELECT primary_uom_code, lot_control_code
6705: INTO l_primary_uom, l_lot_control_code
6706: FROM mtl_system_items
6707: WHERE organization_id = p_organization_id
6708: AND inventory_item_id = p_inventory_item_id;
6709:
6710: IF ( p_source = LPN_CONTEXT_WIP ) THEN

Line 7725: FROM mtl_system_items

7721: FOR v_lpn_serial_content IN lpn_serial_contents_cursor LOOP
7722: /* Get the primary UOM for the serialized item */
7723: SELECT primary_uom_code
7724: INTO l_temp_uom_code
7725: FROM mtl_system_items
7726: WHERE inventory_item_id = v_lpn_serial_content.inventory_item_id
7727: AND organization_id = v_lpn_serial_content.current_organization_id;
7728:
7729: l_container_content_rec.parent_lpn_id := v_lpn_serial_content.lpn_id;

Line 7799: FROM mtl_system_items

7795: FOR v_lpn_serial_content IN lpn_serial_contents_cursor LOOP
7796: /* Get the primary UOM for the serialized item */
7797: SELECT primary_uom_code
7798: INTO l_temp_uom_code
7799: FROM mtl_system_items
7800: WHERE inventory_item_id = v_lpn_serial_content.inventory_item_id
7801: AND organization_id = v_lpn_serial_content.current_organization_id;
7802:
7803: l_container_content_rec.parent_lpn_id := v_lpn_serial_content.lpn_id;

Line 8267: FROM mtl_system_items

8263:
8264: -- Find the primary uom
8265: SELECT primary_uom_code
8266: INTO l_primary_uom
8267: FROM mtl_system_items
8268: WHERE organization_id = p_organization_id
8269: AND inventory_item_id = l_next_item_rec.inventory_item_id;
8270:
8271: LOOP

Line 8504: FROM mtl_system_items

8500: -- If next record is for a new item need to find the primary uom
8501: IF ( l_crnt_item_rec.inventory_item_id <> l_next_item_rec.inventory_item_id ) THEN
8502: SELECT primary_uom_code
8503: INTO l_primary_uom
8504: FROM mtl_system_items
8505: WHERE organization_id = p_organization_id
8506: AND inventory_item_id = l_crnt_item_rec.inventory_item_id;
8507: END IF;
8508: l_insert_item_rec := FALSE;