DBA Data[Home] [Help]

APPS.WIP_RES_USAGE_DEFAULT dependencies on WIP_OPERATION_RESOURCES

Line 118: from wip_operation_resources

114:
115: ELSE
116:
117: select count(*) into l_oper_resource
118: from wip_operation_resources
119: where wip_entity_id = p_wip_entity_id
120: and organization_id = p_organization_id
121: and operation_seq_num = p_operation_seq_num
122: and resource_seq_num = p_resource_seq_num;

Line 135: FROM WIP_OPERATION_RESOURCES

131: l_request_id,
132: l_program_application_id,
133: l_program_id,
134: l_program_update_date
135: FROM WIP_OPERATION_RESOURCES
136: WHERE wip_entity_id = p_wip_entity_id
137: AND organization_id = p_organization_id
138: AND operation_seq_num = p_operation_seq_num
139: AND resource_seq_num = p_resource_seq_num;