DBA Data[Home] [Help]

APPS.WMS_TASK_UTILS_PVT dependencies on MTL_SECONDARY_INVENTORIES

Line 1125: FROM mtl_secondary_inventories

1121: IF ( mmtt_row.primary_quantity < 0 ) THEN --Bug#5984021
1122: -- bug 4230494
1123: SELECT lpn_controlled_flag
1124: INTO l_lpn_control_flag
1125: FROM mtl_secondary_inventories
1126: WHERE organization_id = mmt_row.organization_id
1127: AND secondary_inventory_name = Nvl(mmt_row.transfer_subinventory, mmt_row.subinventory_code);
1128: ELSE
1129: SELECT lpn_controlled_flag

Line 1131: FROM mtl_secondary_inventories

1127: AND secondary_inventory_name = Nvl(mmt_row.transfer_subinventory, mmt_row.subinventory_code);
1128: ELSE
1129: SELECT lpn_controlled_flag
1130: INTO l_lpn_control_flag
1131: FROM mtl_secondary_inventories
1132: WHERE organization_id = mmt_row.organization_id
1133: AND secondary_inventory_name = Nvl(mmt_row.subinventory_code, mmt_row.transfer_subinventory);
1134: END IF;
1135: