DBA Data[Home] [Help]

APPS.CSP_PARTS_ORDER dependencies on JTF_TASK_ASSIGNMENTS

Line 1201: from jtf_task_assignments jta,

1197: SELECT crh.address_type,
1198: crh.ship_to_location_id,
1199: decode(crh.task_assignment_id,null,crh.resource_id,jta.resource_id),
1200: decode(crh.task_assignment_id,null,crh.resource_type,jta.resource_type_code)
1201: from jtf_task_assignments jta,
1202: csp_requirement_headers crh
1203: where jta.task_assignment_id(+) = crh.task_assignment_id
1204: and crh.requirement_header_id = p_rqmt_header_id;
1205: