DBA Data[Home] [Help]

APPS.WSMPUTIL dependencies on MTL_SYSTEM_ITEMS_KFV

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 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');