DBA Data[Home] [Help]

APPS.CSM_NOTIFICATION_EVENT_PKG dependencies on OE_ORDER_HEADERS_ALL

Line 1223: , OE_ORDER_LINES_ALL ol, OE_ORDER_HEADERS_ALL oh

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
1227: AND acc.requirement_line_id = crld.requirement_line_id