DBA Data[Home] [Help]

APPS.INV_MWB_LPN_TREE dependencies on MTL_SYSTEM_ITEMS

Line 574: FROM mtl_system_items

570: serial_number_control_code
571: INTO l_rev_control,
572: l_lot_control,
573: l_serial_control
574: FROM mtl_system_items
575: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
576: AND organization_id = inv_mwb_globals.g_organization_id;
577:
578: -- If all material locations are unchecked and the view by is LPN

Line 892: FROM mtl_system_items

888: SELECT lot_control_code,
889: serial_number_control_code
890: INTO l_lot_control,
891: l_serial_control
892: FROM mtl_system_items
893: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
894: AND organization_id = inv_mwb_globals.g_organization_id;
895:
896: -- If all material locations are unchecked and the view by is LPN

Line 1189: FROM mtl_system_items

1185: ELSIF inv_mwb_globals.g_tree_event = 'TREE_NODE_SELECTED' THEN
1186:
1187: SELECT serial_number_control_code
1188: INTO l_serial_control
1189: FROM mtl_system_items
1190: WHERE inventory_item_id = inv_mwb_globals.g_tree_item_id
1191: AND organization_id = inv_mwb_globals.g_organization_id;
1192:
1193: IF inv_mwb_globals.g_chk_onhand = 0