APPS.CSM_CSP_REQ_LINES_EVENT_PKG dependencies on ASG_USER

Line 345: oe_order_lines_all c ,asg_user au

341: INSERT INTO CSM_REQ_LINE_DETAILS_ACC(ACCESS_ID,REQ_LINE_DETAIL_ID,USER_ID,ITEM_ID,ORG_ID,SOURCE_ID,CREATION_DATE,LAST_UPDATE_DATE,CREATED_BY,LAST_UPDATED_BY)
342: select CSM_REQ_LINES_ACC_S.nextval,req_line_detail_id,user_id,b.inventory_item_id,d.destination_organization_id,b.source_id,sysdate,sysdate,1,1
343: from (select b.req_line_detail_id,a.user_id,c.inventory_item_id,b.requirement_line_id,b.source_id
344: from csm_req_lines_acc a, csp_req_line_details b ,
345: oe_order_lines_all c ,asg_user au
346: where a.requirement_line_id=b.requirement_line_id
347: and b.source_type= 'IO' and b.source_id=c.line_id
348: and b.req_line_detail_id=l_req_line_detail_id
349: and au.user_id=a.user_id

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

348: and b.req_line_detail_id=l_req_line_detail_id
349: and au.user_id=a.user_id
350: UNION ALL
351: select b.req_line_detail_id,a.user_id,c.inventory_item_id,b.requirement_line_id,b.source_id
352: from csm_req_lines_acc a, csp_req_line_details b , mtl_reservations c,asg_user au
353: where a.requirement_line_id=b.requirement_line_id
354: and b.source_type= 'RES' and b.source_id=c.reservation_id
355: and b.req_line_detail_id=l_req_line_detail_id
356: and au.user_id=a.user_id ) b,