DBA Data[Home] [Help]

APPS.INV_PICK_RELEASE_PUB dependencies on MTL_SYSTEM_ITEMS

Line 1194: FROM mtl_system_items

1190: primary_uom_code, NVL(reservable_type,1)
1191: INTO l_revision_control_code, l_lot_control_code,
1192: l_primary_uom_tbl(l_item_index),
1193: l_reservable_type
1194: FROM mtl_system_items
1195: WHERE organization_id = l_organization_id
1196: AND inventory_item_id = l_item_index;
1197: EXCEPTION
1198: WHEN no_data_found THEN

Line 2904: FROM mtl_system_items msi

2900: WHERE line_status = 5
2901: AND line_id = l_mol_id_tbl(ii)
2902: AND EXISTS
2903: ( SELECT 'x'
2904: FROM mtl_system_items msi
2905: WHERE msi.organization_id = mtrl.organization_id
2906: AND msi.inventory_item_id = mtrl.inventory_item_id
2907: AND NVL(msi.reservable_type,1) = 1
2908: );