DBA Data[Home] [Help]

APPS.INV_RESERVATION_PVT dependencies on WIP_ENTITIES

Line 2609: l_wip_entity_id, l_maintenance_object_source FROM wip_entities we,

2605: END IF;
2606:
2607: BEGIN
2608: SELECT we.entity_type, wdj.maintenance_object_source INTO
2609: l_wip_entity_id, l_maintenance_object_source FROM wip_entities we,
2610: wip_discrete_jobs wdj WHERE we.wip_entity_id = p_source_header_id
2611: AND we.wip_entity_id = wdj.wip_entity_id(+);
2612: EXCEPTION
2613: WHEN no_data_found THEN

Line 8737: FROM wip_entities we, wip_discrete_jobs wdj

8733:
8734: BEGIN
8735: SELECT we.entity_type, wdj.maintenance_object_source
8736: INTO l_wip_entity_id, l_maintenance_object_source
8737: FROM wip_entities we, wip_discrete_jobs wdj
8738: WHERE we.wip_entity_id = l_to_rsv_rec.demand_source_header_id
8739: AND we.wip_entity_id = wdj.wip_entity_id(+);
8740: EXCEPTION
8741: WHEN no_data_found THEN

Line 10454: FROM wip_entities we, wip_discrete_jobs wdj

10450: ELSIF ( (l_to_rsv_rec.demand_source_type_id = inv_reservation_global.g_source_type_wip) AND (l_pjm_enabled = 1)) THEN
10451: BEGIN
10452: SELECT we.entity_type, wdj.maintenance_object_source
10453: INTO l_wip_entity_id, l_maintenance_object_source
10454: FROM wip_entities we, wip_discrete_jobs wdj
10455: WHERE we.wip_entity_id = l_to_rsv_rec.demand_source_header_id
10456: AND we.wip_entity_id = wdj.wip_entity_id(+);
10457: EXCEPTION
10458: WHEN no_data_found THEN

Line 13610: FROM wip_entities we, wip_discrete_jobs wdj

13606: ELSIF ( (l_to_rsv_rec.demand_source_type_id = inv_reservation_global.g_source_type_wip) AND (l_pjm_enabled = 1)) THEN
13607: BEGIN
13608: SELECT we.entity_type, wdj.maintenance_object_source
13609: INTO l_wip_entity_id, l_maintenance_object_source
13610: FROM wip_entities we, wip_discrete_jobs wdj
13611: WHERE we.wip_entity_id = l_to_rsv_rec.demand_source_header_id
13612: AND we.wip_entity_id = wdj.wip_entity_id(+);
13613: EXCEPTION
13614: WHEN no_data_found THEN