eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSM_CSP_REQ_LINES_EVENT_PKG dependencies on CSP_REQ_LINE_DETAILS

Line 146: , CSP_REQ_LINE_DETAILS crld

142: IS
143: SELECT acc.user_id
144: , acc.access_id
145: FROM csm_req_lines_acc acc
146: , CSP_REQ_LINE_DETAILS crld
147: , OE_ORDER_LINES_ALL ol
148: WHERE acc.requirement_line_id = crld.requirement_line_id
149: AND crld.source_id = ol.line_id
150: AND crld.SOURCE_TYPE='IO'

Line 155: FROM oe_order_lines_all ol,csm_req_lines_acc ACC, CSP_REQ_LINE_DETAILS crld

151: AND ol.LAST_UPDATE_DATE >= b_last_run_date */
152:
153: CURSOR c_order_info (b_last_run_date DATE) IS
154: SELECT ol.line_id,acc.user_id,acc.requirement_line_id
155: FROM oe_order_lines_all ol,csm_req_lines_acc ACC, CSP_REQ_LINE_DETAILS crld
156: WHERE acc.requirement_line_id= crld.requirement_line_id and crld.source_type='IO' and ol.line_id=crld.source_id
157: AND ol.last_update_date > b_last_run_date
158: UNION ALL
159: SELECT ol.line_id,acc.user_id ,acc.requirement_line_id

Line 160: FROM oe_order_lines_all ol,csm_req_lines_acc ACC, CSP_REQ_LINE_DETAILS crld

156: WHERE acc.requirement_line_id= crld.requirement_line_id and crld.source_type='IO' and ol.line_id=crld.source_id
157: AND ol.last_update_date > b_last_run_date
158: UNION ALL
159: SELECT ol.line_id,acc.user_id ,acc.requirement_line_id
160: FROM oe_order_lines_all ol,csm_req_lines_acc ACC, CSP_REQ_LINE_DETAILS crld
161: WHERE acc.requirement_line_id= crld.requirement_line_id and crld.source_type='IO' and ol.line_id=crld.source_id
162: AND ol.last_update_date < b_last_run_date
163: and ol.flow_status_code in ('AWAITING_SHIPPING' ,'PRODUCTION_COMPLETE')
164: AND EXISTS(SELECT 1 FROM wsh_delivery_details WHERE source_line_id=ol.line_id AND source_code = 'OE' AND LAST_UPDATE_DATE > b_last_run_date);

Line 172: , CSP_REQ_LINE_DETAILS crld

168: IS
169: SELECT acc.user_id
170: , res.reservation_id
171: FROM csm_req_lines_acc acc
172: , CSP_REQ_LINE_DETAILS crld
173: , MTL_RESERVATIONS res
174: WHERE acc.requirement_line_id = crld.requirement_line_id
175: AND crld.source_id = res.RESERVATION_ID
176: AND crld.SOURCE_TYPE='RES'

Line 315: l_req_line_detail_id csp_req_line_details.req_line_detail_id%TYPE :=p_rld;

311: l_sqlerrmsg VARCHAR2(4000);
312: l_dummy boolean;
313: l_src VARCHAR2(30);
314: l_src_id NUMBER;
315: l_req_line_detail_id csp_req_line_details.req_line_detail_id%TYPE :=p_rld;
316: l_req_line_id csp_requirement_lines.requirement_line_id%TYPE;
317: l_found BOOLEAN:=false;
318: l_access_id NUMBER;
319: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;

Line 330: SELECT REQUIREMENT_LINE_ID,SOURCE_TYPE,SOURCE_ID INTO l_req_line_id,l_src,l_src_id FROM CSP_REQ_LINE_DETAILS WHERE req_line_detail_id=l_req_line_detail_id;

326: BEGIN
327: CSM_UTIL_PKG.LOG('Entering REQ_LINE_DTL_IUD for req_line_dtl_id:' || p_rld||' with DML:'||p_DML_t,
328: 'CSM_CSP_REQ_LINES_EVENT_PKG.REQ_LINE_DTL_IUD',FND_LOG.LEVEL_PROCEDURE);
329:
330: SELECT REQUIREMENT_LINE_ID,SOURCE_TYPE,SOURCE_ID INTO l_req_line_id,l_src,l_src_id FROM CSP_REQ_LINE_DETAILS WHERE req_line_detail_id=l_req_line_detail_id;
331:
332: CSM_UTIL_PKG.LOG('Processing req_line_id:'||l_req_line_id||fnd_global.local_chr(10)||'req line detail_id:'||l_req_line_detail_id
333: ||fnd_global.local_chr(10)||'src type:'||l_src
334: ||fnd_global.local_chr(10)||'src id:'||l_src_id, 'CSM_CSP_REQ_LINES_EVENT_PKG.REQ_LINE_DTL_IUD', FND_LOG.LEVEL_PROCEDURE );

Line 344: from csm_req_lines_acc a, csp_req_line_details b ,

340: IF (l_tab_access_id.COUNT=0) AND p_dml_t <> 'D' THEN
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

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,