DBA Data[Home] [Help]

APPS.CSP_PARTS_ORDER dependencies on JTF_TASK_ASSIGNMENTS

Line 1468: from jtf_task_assignments jta,

1464: SELECT crh.address_type,
1465: crh.ship_to_location_id,
1466: decode(crh.task_assignment_id,null,crh.resource_id,jta.resource_id),
1467: decode(crh.task_assignment_id,null,crh.resource_type,jta.resource_type_code)
1468: from jtf_task_assignments jta,
1469: csp_requirement_headers crh
1470: where jta.task_assignment_id(+) = crh.task_assignment_id
1471: and crh.requirement_header_id = p_rqmt_header_id;
1472: