eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WIP_RESOURCE_DEFAULT dependencies on WIP_JOB_DETAILS

Line 60: applied_resource_units = decode(p_substitution_type,WIP_JOB_DETAILS.WIP_ADD,0,applied_resource_units), /Bug 3499921/

56:
57: UPDATE WIP_JOB_DTLS_INTERFACE
58: SET scheduled_flag = nvl(scheduled_flag,2),
59: assigned_units = nvl(assigned_units,1),
60: applied_resource_units = decode(p_substitution_type,WIP_JOB_DETAILS.WIP_ADD,0,applied_resource_units), /*Bug 3499921*/
61: applied_resource_value = decode(p_substitution_type,WIP_JOB_DETAILS.WIP_ADD,0,applied_resource_value), /*Bug 3499921*/
62: usage_rate_or_amount = decode(usage_rate_or_amount,NULL,NULL,
63: inv_convert.inv_um_convert(0,WIP_CONSTANTS.MAX_DISPLAYED_PRECISION,usage_rate_or_amount,
64: nvl(uom_code,x_uom_code), x_uom_code,

Line 61: applied_resource_value = decode(p_substitution_type,WIP_JOB_DETAILS.WIP_ADD,0,applied_resource_value), /Bug 3499921/

57: UPDATE WIP_JOB_DTLS_INTERFACE
58: SET scheduled_flag = nvl(scheduled_flag,2),
59: assigned_units = nvl(assigned_units,1),
60: applied_resource_units = decode(p_substitution_type,WIP_JOB_DETAILS.WIP_ADD,0,applied_resource_units), /*Bug 3499921*/
61: applied_resource_value = decode(p_substitution_type,WIP_JOB_DETAILS.WIP_ADD,0,applied_resource_value), /*Bug 3499921*/
62: usage_rate_or_amount = decode(usage_rate_or_amount,NULL,NULL,
63: inv_convert.inv_um_convert(0,WIP_CONSTANTS.MAX_DISPLAYED_PRECISION,usage_rate_or_amount,
64: nvl(uom_code,x_uom_code), x_uom_code,
65: null,null)), /* fix for bug#2367650 +APS*/

Line 69: WIP_JOB_DETAILS.WIP_ADD,

65: null,null)), /* fix for bug#2367650 +APS*/
66: uom_code = x_uom_code,
67: basis_type = nvl(basis_type,x_basis_type),/*Fix for bug 2119945*/
68: activity_id = decode(p_substitution_type,
69: WIP_JOB_DETAILS.WIP_ADD,
70: nvl(activity_id,x_activity_id),
71: activity_id), /*Bug 2683271*/
72: autocharge_type = nvl(autocharge_type,x_autocharge_type), /*Fix for bug 6767640*/
73: standard_rate_flag = nvl(standard_rate_flag,x_standard_rate_flag), /*Fix for bug 6767640*/

Line 79: AND load_type in (WIP_JOB_DETAILS.WIP_RESOURCE,

75: completion_date = nvl(completion_date,x_completion_date)
76: WHERE group_id = p_group_id
77: AND wip_entity_id = p_wip_entity_id
78: AND organization_id = p_organization_id
79: AND load_type in (WIP_JOB_DETAILS.WIP_RESOURCE,
80: WIP_JOB_DETAILS.WIP_SUB_RES)
81: AND substitution_type = p_substitution_type
82: AND operation_seq_num = p_operation_seq_num
83: AND resource_seq_num = p_resource_seq_num

Line 80: WIP_JOB_DETAILS.WIP_SUB_RES)

76: WHERE group_id = p_group_id
77: AND wip_entity_id = p_wip_entity_id
78: AND organization_id = p_organization_id
79: AND load_type in (WIP_JOB_DETAILS.WIP_RESOURCE,
80: WIP_JOB_DETAILS.WIP_SUB_RES)
81: AND substitution_type = p_substitution_type
82: AND operation_seq_num = p_operation_seq_num
83: AND resource_seq_num = p_resource_seq_num
84: AND resource_id_new = p_resource_id_new

Line 86: AND not ( load_type = wip_job_details.wip_resource

82: AND operation_seq_num = p_operation_seq_num
83: AND resource_seq_num = p_resource_seq_num
84: AND resource_id_new = p_resource_id_new
85: -- jy: no need to default if doing res substitution
86: AND not ( load_type = wip_job_details.wip_resource
87: and substitution_type = wip_job_details.wip_change
88: and substitute_group_num is not null
89: and substitute_group_num is not null
90: );

Line 87: and substitution_type = wip_job_details.wip_change

83: AND resource_seq_num = p_resource_seq_num
84: AND resource_id_new = p_resource_id_new
85: -- jy: no need to default if doing res substitution
86: AND not ( load_type = wip_job_details.wip_resource
87: and substitution_type = wip_job_details.wip_change
88: and substitute_group_num is not null
89: and substitute_group_num is not null
90: );
91: