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 OE_ORDER_LINES_ALL

Line 147: , OE_ORDER_LINES_ALL ol

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'
151: AND ol.LAST_UPDATE_DATE >= b_last_run_date */

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 188: SELECT HEADER_ID FROM OE_ORDER_LINES_ALL WHERE LINE_ID=b_line_id;

184: l_dummy BOOLEAN;
185: l_current_run_date DATE;
186:
187: CURSOR c_hdr_id(b_line_id NUMBER) IS
188: SELECT HEADER_ID FROM OE_ORDER_LINES_ALL WHERE LINE_ID=b_line_id;
189:
190: l_hrd_id NUMBER;
191: BEGIN
192: CSM_UTIL_PKG.LOG('Entering CONC_ORDER_UPDATE','CSM_CSP_REQ_LINES_EVENT_PKG.CONC_ORDER_UPDATE',FND_LOG.LEVEL_PROCEDURE);

Line 308: SELECT HEADER_ID FROM OE_ORDER_LINES_ALL WHERE LINE_ID=b_line_id;

304: CURSOR c_get_dtl IS
305: SELECT ACCESS_ID,USER_ID,SOURCE_ID FROM CSM_REQ_LINE_DETAILS_ACC WHERE REQ_LINE_DETAIL_ID=p_rld;
306:
307: CURSOR c_hdr_id(b_line_id NUMBER) IS
308: SELECT HEADER_ID FROM OE_ORDER_LINES_ALL WHERE LINE_ID=b_line_id;
309:
310: l_sqlerrno VARCHAR2(20);
311: l_sqlerrmsg VARCHAR2(4000);
312: l_dummy boolean;

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