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 CSM_REQ_LINES_ACC

Line 16: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_REQ_LINES_ACC';

12: -- --------- ------ ------------------------------------------
13: -- Enter procedure, function bodies as shown below
14:
15: g_table_name1 CONSTANT VARCHAR2(30) := 'CSP_REQUIREMENT_LINES';
16: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_REQ_LINES_ACC';
17: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_REQ_LINES_ACC_S';
18: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
19: CSM_ACC_PKG.t_publication_item_list('CSM_REQ_LINES');
20: g_pk1_name1 CONSTANT VARCHAR2(30) := 'REQUIREMENT_LINE_ID';

Line 17: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_REQ_LINES_ACC_S';

13: -- Enter procedure, function bodies as shown below
14:
15: g_table_name1 CONSTANT VARCHAR2(30) := 'CSP_REQUIREMENT_LINES';
16: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_REQ_LINES_ACC';
17: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_REQ_LINES_ACC_S';
18: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
19: CSM_ACC_PKG.t_publication_item_list('CSM_REQ_LINES');
20: g_pk1_name1 CONSTANT VARCHAR2(30) := 'REQUIREMENT_LINE_ID';
21:

Line 145: FROM csm_req_lines_acc acc

141: /*CURSOR c_order_info (b_last_run_date DATE)
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

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 171: FROM csm_req_lines_acc acc

167: CURSOR c_res_info (b_last_run_date DATE)
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

Line 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

338: CLOSE c_get_dtl;
339:
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

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,