APPS.CSM_MTL_SYSTEM_ITEMS_EVENT_PKG dependencies on CSM_REQ_LINES_ACC

Line 1092: from csm_req_lines_acc a, csp_req_line_details b ,

1088: CURSOR c_htm5_mtl_items
1089: IS
1090: SELECT csm_mtl_system_items_acc_s.NEXTVAL,inventory_item_id,org_id ,user_id
1091: FROM ( select c.inventory_item_id,d.destination_organization_id org_id ,a.user_id
1092: from csm_req_lines_acc a, csp_req_line_details b ,
1093: oe_order_lines_all c,csp_requirement_headers d
1094: ,csp_requirement_lines e ,asg_user au
1095: where a.requirement_line_id=b.requirement_line_id
1096: and b.source_type= 'IO' and b.source_id=c.line_id

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