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_NOTIFICATION_EVENT_PKG dependencies on CSM_REQ_LINES_ACC

Line 1221: FROM csm_req_lines_acc acc

1217: SELECT acc.USER_ID,usr.USER_NAME,usr.email_address,
1218: acc.requirement_line_id,oh.order_number,
1219: CSP_PICK_UTILS.get_order_status (ol.LINE_ID, ol.FLOW_STATUS_CODE) order_status,
1220: nvl(ol.actual_arrival_date,ol.schedule_arrival_date) arrival_date
1221: FROM csm_req_lines_acc acc
1222: , CSP_REQ_LINE_DETAILS crld
1223: , OE_ORDER_LINES_ALL ol, OE_ORDER_HEADERS_ALL oh
1224: , fnd_user usr,asg_user au
1225: WHERE acc.access_id=b_acc_id

Line 1236: FROM CSM_REQ_LINES_ACC acc,

1232:
1233: CURSOR c_req_details(b_req_detail_id NUMBER)
1234: IS
1235: SELECT ACCESS_ID
1236: FROM CSM_REQ_LINES_ACC acc,
1237: CSP_REQ_LINE_DETAILS dtl
1238: WHERE REQ_LINE_DETAIL_ID = b_req_detail_id
1239: AND acc.requirement_line_id = dtl.requirement_line_id;
1240: