VIEW: APPS.CSM_MTL_RESERVATIONS_V

Source

View Text - Preformatted

SELECT res.reservation_id access_id, res.reservation_id, res.organization_id, res.subinventory_code, res.locator_id, res.lot_number, res.revision, res.inventory_item_id, res.serial_number, nvl(res.demand_source_line_id, acc.REQUIREMENT_LINE_ID) demand_source_line_id, reservation_quantity, reservation_uom_code ,tsk.task_number res_task_num ,0 RECEIVED_QTY from csm_req_lines_acc acc,mtl_reservations res ,csp_requirement_lines rl,csp_requirement_headers rh,jtf_tasks_b tsk ,csp_req_line_details crld WHERE acc.REQUIREMENT_LINE_ID =crld.REQUIREMENT_LINE_ID and res.reservation_id=crld.source_id and crld.source_type='RES' and acc.user_id=asg_base.get_user_id and rl.REQUIREMENT_LINE_ID=acc.REQUIREMENT_LINE_ID and rl.REQUIREMENT_HEADER_ID=rh.REQUIREMENT_HEADER_ID and rh.task_id=tsk.task_id(+)

View Text - HTML Formatted

SELECT RES.RESERVATION_ID ACCESS_ID
, RES.RESERVATION_ID
, RES.ORGANIZATION_ID
, RES.SUBINVENTORY_CODE
, RES.LOCATOR_ID
, RES.LOT_NUMBER
, RES.REVISION
, RES.INVENTORY_ITEM_ID
, RES.SERIAL_NUMBER
, NVL(RES.DEMAND_SOURCE_LINE_ID
, ACC.REQUIREMENT_LINE_ID) DEMAND_SOURCE_LINE_ID
, RESERVATION_QUANTITY
, RESERVATION_UOM_CODE
, TSK.TASK_NUMBER RES_TASK_NUM
, 0 RECEIVED_QTY
FROM CSM_REQ_LINES_ACC ACC
, MTL_RESERVATIONS RES
, CSP_REQUIREMENT_LINES RL
, CSP_REQUIREMENT_HEADERS RH
, JTF_TASKS_B TSK
, CSP_REQ_LINE_DETAILS CRLD
WHERE ACC.REQUIREMENT_LINE_ID =CRLD.REQUIREMENT_LINE_ID
AND RES.RESERVATION_ID=CRLD.SOURCE_ID
AND CRLD.SOURCE_TYPE='RES'
AND ACC.USER_ID=ASG_BASE.GET_USER_ID
AND RL.REQUIREMENT_LINE_ID=ACC.REQUIREMENT_LINE_ID
AND RL.REQUIREMENT_HEADER_ID=RH.REQUIREMENT_HEADER_ID
AND RH.TASK_ID=TSK.TASK_ID(+)