DBA Data[Home] [Help]

APPS.XDP_ORDER dependencies on XDP_SERVICE_VAL_ACTS

Line 451: FROM xdp_service_val_acts

447: /*** Cursor to check valid Service Action combination ***/
448:
449: CURSOR c_srv_action (p_action_code IN VARCHAR2) IS
450: SELECT service_val_act_id
451: FROM xdp_service_val_acts
452: WHERE organization_id = p_organization_id
453: AND inventory_item_id = p_inventory_item_id
454: AND action_source = p_action_source
455: AND action_code = p_action_code

Line 4400: XDP_SERVICE_VAL_ACTS svn,

4396: ,wi.TIME_ESTIMATE
4397: ,wi.PROTECTED_FLAG
4398: ,wi.ROLE_NAME
4399: from XDP_SERVICE_WI_MAP swp,
4400: XDP_SERVICE_VAL_ACTS svn,
4401: XDP_WORKITEMS wi
4402: where swp.service_val_act_id = svn.service_val_act_id and
4403: svn.inventory_item_id = l_inventory_item_id and
4404: svn.organization_id = l_organization_id and

Line 4552: FROM xdp_service_val_acts svn

4548: lv_srv_config := 'N';
4549:
4550: SELECT wi_mapping_proc
4551: INTO lv_wi_map_proc
4552: FROM xdp_service_val_acts svn
4553: WHERE svn.inventory_item_id = p_service_order_line_list(lv_index).inventory_item_id
4554: AND svn.organization_id = p_service_order_line_list(lv_index).organization_id
4555: AND svn.action_code = p_service_order_line_list(lv_index).action_code;
4556: