DBA Data[Home] [Help]

APPS.CSD_MASS_RCV_PVT dependencies on MTL_SYSTEM_ITEMS

Line 2611: FROM mtl_system_items

2607: END IF;
2608:
2609: SELECT serial_number_control_code
2610: INTO l_serial_code
2611: FROM mtl_system_items
2612: WHERE inventory_item_id = p_inv_item_id
2613: AND organization_id = cs_std.get_item_valdn_orgzn_id;
2614:
2615: IF l_serial_code = 2

Line 2648: FROM mtl_system_items

2644: l_ib_trackable_flag VARCHAR2 (1) ;
2645: BEGIN
2646: SELECT NVL (comms_nl_trackable_flag, 'N')
2647: INTO l_ib_trackable_flag
2648: FROM mtl_system_items
2649: WHERE inventory_item_id = p_inv_item_id
2650: AND organization_id = cs_std.get_item_valdn_orgzn_id;
2651:
2652: IF l_ib_trackable_flag = 'Y'