DBA Data[Home] [Help]

APPS.WSMPUTIL dependencies on MTL_SYSTEM_ITEMS

Line 545: -- FROM MTL_SYSTEM_ITEMS MSI

541:
542: -- SELECT NVL(MSI.CUM_MANUFACTURING_LEAD_TIME, 0)
543: -- SELECT NVL(MSI.full_lead_time, 0)
544: -- INTO l_cum_mfg_lead_time
545: -- FROM MTL_SYSTEM_ITEMS MSI
546: -- WHERE MSI.organization_id = p_organization_id
547: -- AND MSI.inventory_item_id = p_primary_item_id;
548:
549: SELECT nvl(fixed_lead_time,0), nvl(variable_lead_time,0)

Line 551: FROM MTL_SYSTEM_ITEMS

547: -- AND MSI.inventory_item_id = p_primary_item_id;
548:
549: SELECT nvl(fixed_lead_time,0), nvl(variable_lead_time,0)
550: INTO l_fixed_lead_time, l_variable_lead_time
551: FROM MTL_SYSTEM_ITEMS
552: WHERE organization_id = p_organization_id
553: AND inventory_item_id = p_primary_item_id;
554:
555: IF (SQL%NOTFOUND) THEN

Line 2271: from mtl_system_items_kfv msi

2267:
2268: BEGIN
2269: select 1
2270: into l_no_of_records
2271: from mtl_system_items_kfv msi
2272: where msi.inventory_item_id = p_assembly_item_id
2273: and msi.organization_id = p_organization_id
2274: and msi.lot_control_code = 2;
2275: EXCEPTION

Line 2294: from mtl_system_items_kfv msi

2290: serial_number_control_code
2291: into l_no_of_records,
2292: -- ST : Serial Support Project -----------------------------
2293: l_serial_control_code
2294: from mtl_system_items_kfv msi
2295: where msi.inventory_item_id = p_assembly_item_id
2296: and msi.organization_id = p_organization_id
2297: -- ST : Serial Support Project --------------
2298: and msi.serial_number_control_code IN (1,2);

Line 2319: from mtl_system_items_kfv msi

2315: l_stmt_num := 40;
2316: BEGIN
2317: select 1
2318: into l_dummy
2319: from mtl_system_items_kfv msi
2320: where msi.inventory_item_id = p_routing_reference_id
2321: and msi.organization_id = p_organization_id;
2322: EXCEPTION
2323: when too_many_rows then null;

Line 2341: from mtl_system_items_kfv msi

2337: if p_bom_reference_id is not null then
2338: BEGIN
2339: select 1
2340: into l_dummy
2341: from mtl_system_items_kfv msi
2342: where msi.inventory_item_id = p_bom_reference_id
2343: and msi.organization_id = p_organization_id;
2344: EXCEPTION
2345: when too_many_rows then null;

Line 2570: FROM mtl_system_items MS,

2566: MS.restrict_locators_code,
2567: MS.location_control_code item_loc_control
2568: into l_sub_loc_control, l_org_loc_control,
2569: l_restrict_locators_code, l_item_loc_control
2570: FROM mtl_system_items MS,
2571: mtl_secondary_inventories MSUB,
2572: mtl_parameters MP
2573: WHERE MP.organization_id = p_organization_id
2574: AND MS.organization_id = p_organization_id

Line 6055: l_item MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;

6051: x_error_msg OUT NOCOPY VARCHAR2
6052: )
6053: return varchar2 is
6054: l_status_applicable VARCHAR2(1) := 'Y';
6055: l_item MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;
6056: l_locator MTL_ITEM_LOCATIONS_KFV.CONCATENATED_SEGMENTS%TYPE;
6057: BEGIN
6058: IF (p_inventory_item_id IS NOT NULL and p_sub_code IS NOT NULL) THEN
6059: l_status_applicable := INV_MATERIAL_STATUS_GRP.is_status_applicable(p_wms_installed => p_wms_installed,

Line 6128: from mtl_system_items_kfv

6124:
6125: IF l_status_applicable = 'N' THEN
6126: select concatenated_segments
6127: into l_item
6128: from mtl_system_items_kfv
6129: where inventory_item_id = p_inventory_item_id
6130: and organization_id = p_organization_id;
6131:
6132: FND_MESSAGE.SET_NAME('INV','INV_TRX_LOT_NA_DUE_MS');

Line 6157: from mtl_system_items_kfv

6153:
6154: IF l_status_applicable = 'N' THEN
6155: select concatenated_segments
6156: into l_item
6157: from mtl_system_items_kfv
6158: where inventory_item_id = p_inventory_item_id
6159: and organization_id = p_organization_id;
6160:
6161: FND_MESSAGE.SET_NAME('INV','INV_TRX_SER_NA_DUE_MS');