DBA Data[Home] [Help]

APPS.WMS_TASK_UTILS_PVT dependencies on MTL_SECONDARY_INVENTORIES

Line 1122: FROM mtl_secondary_inventories

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

Line 1128: FROM mtl_secondary_inventories

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