DBA Data[Home] [Help]

APPS.CSM_DEBRIEF_EVENT_PKG dependencies on JTF_RS_RESOURCE_EXTNS

Line 166: jtf_rs_resource_extns jtrs

162: NVL(NVL(issuing_inventory_org_id, receiving_inventory_org_id), csm_profile_pkg.get_organization_id(jtrs.user_id)) AS organization_id
163: FROM csf_debrief_lines dbl,
164: csf_debrief_headers dhdr,
165: jtf_task_assignments jta,
166: jtf_rs_resource_extns jtrs
167: WHERE dbl.debrief_line_id = p_debrief_line_id
168: AND dbl.debrief_header_id = dhdr.debrief_header_id
169: AND jta.task_assignment_id = dhdr.task_assignment_id
170: AND jtrs.resource_id (+)= jta.resource_id

Line 371: jtf_rs_resource_extns jtrs

367: FROM csf_debrief_lines dbl,
368: csf_debrief_headers dhdr,
369: csm_debrief_lines_acc acc,
370: jtf_task_assignments jta,
371: jtf_rs_resource_extns jtrs
372: WHERE dbl.debrief_line_id = p_debrief_line_id
373: AND dbl.debrief_header_id = dhdr.debrief_header_id
374: AND jta.task_assignment_id = dhdr.task_assignment_id
375: AND jtrs.resource_id = jta.resource_id