DBA Data[Home] [Help]

APPS.RCV_DEFAULT_PKG dependencies on MTL_ITEM_LOCATIONS_KFV

Line 1064: FROM mtl_item_locations_kfv

1060: END IF;
1061:
1062: SELECT inventory_location_id
1063: INTO x_locator_id
1064: FROM mtl_item_locations_kfv
1065: WHERE organization_id = p_org_id
1066: AND concatenated_segments = p_locator
1067: AND ( subinventory_code = NVL(p_subinventory, subinventory_code)
1068: OR subinventory_code IS NULL)

Line 1100: FROM mtl_item_locations_kfv

1096: END IF;
1097:
1098: SELECT concatenated_segments
1099: INTO x_locator
1100: FROM mtl_item_locations_kfv
1101: WHERE organization_id = p_org_id
1102: AND inventory_location_id = p_locator_id
1103: AND ( subinventory_code = NVL(p_subinventory, subinventory_code)
1104: OR subinventory_code IS NULL)