DBA Data[Home] [Help]

APPS.M4R_7B1_WSM_IN dependencies on MTL_SYSTEM_ITEMS_KFV

Line 393: g_exception_tracking_msg := 'Querying mtl_system_items_kfv table for x_prev_inventory_item_id';

389: END IF;
390:
391: IF p_start_lot_item IS NOT NULL THEN
392:
393: g_exception_tracking_msg := 'Querying mtl_system_items_kfv table for x_prev_inventory_item_id';
394:
395: SELECT inventory_item_id
396: INTO x_prev_inventory_item_id
397: FROM mtl_system_items_kfv

Line 397: FROM mtl_system_items_kfv

393: g_exception_tracking_msg := 'Querying mtl_system_items_kfv table for x_prev_inventory_item_id';
394:
395: SELECT inventory_item_id
396: INTO x_prev_inventory_item_id
397: FROM mtl_system_items_kfv
398: WHERE concatenated_segments = p_start_lot_item
399: AND organization_id = p_org_id
400: AND inventory_item_status_code = 'Active';
401:

Line 407: g_exception_tracking_msg := 'Querying mtl_system_items_kfv table for PRIMARY_ITEM_CODE';

403: cln_debug_pub.Add('x_prev_inventory_item_id: ' || x_prev_inventory_item_id, 1);
404: END IF;
405: END IF;
406:
407: g_exception_tracking_msg := 'Querying mtl_system_items_kfv table for PRIMARY_ITEM_CODE';
408:
409: SELECT inventory_item_id
410: INTO x_inventory_item_id
411: FROM mtl_system_items_kfv

Line 411: FROM mtl_system_items_kfv

407: g_exception_tracking_msg := 'Querying mtl_system_items_kfv table for PRIMARY_ITEM_CODE';
408:
409: SELECT inventory_item_id
410: INTO x_inventory_item_id
411: FROM mtl_system_items_kfv
412: WHERE concatenated_segments = p_prim_lot_item
413: AND organization_id = p_org_id
414: AND inventory_item_status_code = 'Active';
415: