DBA Data[Home] [Help]

APPS.XNP_CVU_PKG dependencies on XDP_SERVICE_VAL_ACTS

Line 1269: FROM xdp_service_val_acts sva

1265: SELECT service_id id, service_name name
1266: FROM xdp_services s
1267: WHERE NOT EXISTS
1268: (SELECT 1
1269: FROM xdp_service_val_acts sva
1270: WHERE sva.service_id = s.service_id
1271: AND SYSDATE
1272: BETWEEN sva.valid_date
1273: AND nvl(sva.invalid_date,gc_max_date)

Line 1281: FROM xdp_service_val_acts sva, xdp_services s

1277: -- foreign key constraint defined.
1278:
1279: CURSOR c_dservice_wi_map_proc IS
1280: SELECT sva.service_id id, s.service_name name
1281: FROM xdp_service_val_acts sva, xdp_services s
1282: WHERE sva.service_id = s.service_id
1283: AND sva.wi_mapping_type = gc_DYNAMIC
1284: AND sva.wi_mapping_proc is NULL;
1285: */

Line 1294: FROM xdp_service_val_acts sva

1290: CURSOR c_dservice_wi_map_proc IS
1291: SELECT mtl.inventory_item_id id
1292: , mtl.organization_id organization_id
1293: , mtl.concatenated_segments name
1294: FROM xdp_service_val_acts sva
1295: , mtl_system_items_vl mtl
1296: WHERE sva.inventory_item_id = mtl.inventory_item_id
1297: AND sva.organization_id = mtl.organization_id
1298: AND sva.wi_mapping_type = gc_DYNAMIC