DBA Data[Home] [Help]

APPS.INV_UI_ITEM_ATT_LOVS dependencies on MTL_CC_SUBINVENTORIES

Line 1131: FROM mtl_cc_subinventories

1127: AND (l_orientation_code = 1 OR
1128: (msn.current_status = 3
1129: AND msn.current_subinventory_code IN
1130: (SELECT subinventory
1131: FROM mtl_cc_subinventories
1132: WHERE cycle_count_header_id = p_cycle_count_header_id))
1133: OR msn.current_status <> 3
1134: )
1135: AND serial_number LIKE (p_serial_number)

Line 1364: FROM mtl_cc_subinventories

1360: AND (l_orientation_code = 1 OR
1361: (msn.current_status = 3
1362: AND msn.current_subinventory_code IN
1363: (SELECT subinventory
1364: FROM mtl_cc_subinventories
1365: WHERE cycle_count_header_id = p_cycle_count_header_id))
1366: OR msn.current_status <> 3
1367: )
1368: AND (NVL(msn.lot_number, '###') = NVL(p_lot_number, '###')

Line 1584: FROM mtl_cc_subinventories

1580: AND (l_orientation_code = 1 OR
1581: (msn.current_status = 3
1582: AND msn.current_subinventory_code IN
1583: (SELECT subinventory
1584: FROM mtl_cc_subinventories
1585: WHERE cycle_count_header_id = p_cycle_count_header_id))
1586: OR msn.current_status <> 3
1587: )
1588: AND msn.serial_number LIKE (p_serial_number)