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 CSP_REQ_LINE_DETAILS

Line 1222: , CSP_REQ_LINE_DETAILS crld

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
1226: AND acc.USER_ID = usr.USER_ID

Line 1237: CSP_REQ_LINE_DETAILS dtl

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:
1241: