DBA Data[Home] [Help]

APPS.XDP_ENGINE dependencies on XDP_WI_PARAMETERS

Line 418: xdp_wi_parameters wpr,

414: is_value_evaluated,
415: decode(parameter_value,NULL,wpr.default_value,wdl.parameter_value) param_value,
416: parameter_ref_value
417: from
418: xdp_wi_parameters wpr,
419: xdp_worklist_details wdl
420: where
421: wpr.parameter_name = wdl.parameter_name and
422: wpr.workitem_id = wdl.workitem_id and

Line 2180: xdp_wi_parameters wp

2176: SELECT parameter_value
2177: FROM
2178: xdp_worklist_details wd,
2179: xdp_fulfill_worklist fw,
2180: xdp_wi_parameters wp
2181: WHERE FW.line_item_id=p_line_item_id
2182: AND FW.workitem_instance_id = wd.workitem_instance_id
2183: AND wd.workitem_id = wp.workitem_id
2184: AND wd.parameter_name = wp.parameter_name --to do

Line 2257: xdp_wi_parameters wpr,

2253: wpr.evaluation_mode,
2254: wpr.default_value,
2255: NVL(wpr.log_in_audit_trail_flag,'Y') audit_trail_flag
2256: from
2257: xdp_wi_parameters wpr,
2258: xdp_worklist_details wdl
2259: where
2260: wpr.workitem_id = wdl.workitem_id and
2261: wpr.parameter_name = p_parameter_name and

Line 3357: xdp_wi_parameters wpr

3353: wpr.evaluation_procedure,
3354: wpr.evaluation_mode
3355: FROM
3356: xdp_fulfill_worklist xfw,
3357: xdp_wi_parameters wpr
3358: WHERE
3359: xfw.workitem_instance_id = p_wi_instance_id
3360: AND xfw.workitem_id = wpr.workitem_id
3361: AND wpr.evaluation_procedure is not null