DBA Data[Home] [Help]

APPS.CSM_MTL_SYSTEM_ITEMS_EVENT_PKG dependencies on MTL_RESERVATIONS

Line 1102: from csm_req_lines_acc a, csp_req_line_details b , mtl_reservations c,asg_user au

1098: and d.requirement_header_id=e.requirement_header_id
1099: and b.requirement_line_id=e.requirement_line_id
1100: UNION
1101: select c.inventory_item_id,c.organization_id as org_id ,a.user_id
1102: from csm_req_lines_acc a, csp_req_line_details b , mtl_reservations c,asg_user au
1103: where a.requirement_line_id=b.requirement_line_id
1104: and b.source_type= 'RES' and b.source_id=c.reservation_id
1105: and au.user_id=a.user_id and au.multi_platform='Y') d
1106: where not exists(select 1 from csm_mtl_system_items_acc acc