VIEW: APPS.CSM_REQ_LINES_V

Source

View Text - Preformatted

SELECT acc.access_id , lines.requirement_line_id , lines.requirement_header_id , lines.inventory_item_id , csm_util_pkg.item_name(msi.concatenated_segments) AS item_name, msi.description AS item_description, lines.uom_code , lines.required_quantity , lines.ship_complete_flag , lines.revision , lines.source_organization_id , lines.source_subinventory , lines.ordered_quantity , lines.order_line_id , lines.reservation_id , lines.local_reservation_id , lines.order_by_date , csm_util_pkg.get_varchar('X') as shipping_method_code, lines.last_update_date, lines.sourced_from, lines.attribute_category, lines.attribute1, lines.attribute2, lines.attribute3, lines.attribute4, lines.attribute5, lines.attribute6, lines.attribute7, lines.attribute8, lines.attribute9, lines.attribute10, lines.attribute11, lines.attribute12, lines.attribute13, lines.attribute14, lines.attribute15 , lines.LIKELIHOOD, lines.ITEM_SCRATCHPAD, CSM_UTIL_PKG.GET_NUMBER(lines.created_by) AS CREATED_BY, CSM_UTIL_PKG.GET_NUMBER(lines.last_updated_by) AS LAST_UPDATED_BY FROM csm_req_lines_acc acc, csp_requirement_lines lines, mtl_system_items_b_kfv msi, csm_user_inventory_org uorg WHERE acc.user_id = asg_base.get_user_id AND acc.requirement_line_id = lines.requirement_line_id AND msi.inventory_item_id = lines.inventory_item_id AND uorg.user_id=acc.user_id AND msi.organization_id =uorg.organization_id

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, LINES.REQUIREMENT_LINE_ID
, LINES.REQUIREMENT_HEADER_ID
, LINES.INVENTORY_ITEM_ID
, CSM_UTIL_PKG.ITEM_NAME(MSI.CONCATENATED_SEGMENTS) AS ITEM_NAME
, MSI.DESCRIPTION AS ITEM_DESCRIPTION
, LINES.UOM_CODE
, LINES.REQUIRED_QUANTITY
, LINES.SHIP_COMPLETE_FLAG
, LINES.REVISION
, LINES.SOURCE_ORGANIZATION_ID
, LINES.SOURCE_SUBINVENTORY
, LINES.ORDERED_QUANTITY
, LINES.ORDER_LINE_ID
, LINES.RESERVATION_ID
, LINES.LOCAL_RESERVATION_ID
, LINES.ORDER_BY_DATE
, CSM_UTIL_PKG.GET_VARCHAR('X') AS SHIPPING_METHOD_CODE
, LINES.LAST_UPDATE_DATE
, LINES.SOURCED_FROM
, LINES.ATTRIBUTE_CATEGORY
, LINES.ATTRIBUTE1
, LINES.ATTRIBUTE2
, LINES.ATTRIBUTE3
, LINES.ATTRIBUTE4
, LINES.ATTRIBUTE5
, LINES.ATTRIBUTE6
, LINES.ATTRIBUTE7
, LINES.ATTRIBUTE8
, LINES.ATTRIBUTE9
, LINES.ATTRIBUTE10
, LINES.ATTRIBUTE11
, LINES.ATTRIBUTE12
, LINES.ATTRIBUTE13
, LINES.ATTRIBUTE14
, LINES.ATTRIBUTE15
, LINES.LIKELIHOOD
, LINES.ITEM_SCRATCHPAD
, CSM_UTIL_PKG.GET_NUMBER(LINES.CREATED_BY) AS CREATED_BY
, CSM_UTIL_PKG.GET_NUMBER(LINES.LAST_UPDATED_BY) AS LAST_UPDATED_BY
FROM CSM_REQ_LINES_ACC ACC
, CSP_REQUIREMENT_LINES LINES
, MTL_SYSTEM_ITEMS_B_KFV MSI
, CSM_USER_INVENTORY_ORG UORG
WHERE ACC.USER_ID = ASG_BASE.GET_USER_ID
AND ACC.REQUIREMENT_LINE_ID = LINES.REQUIREMENT_LINE_ID
AND MSI.INVENTORY_ITEM_ID = LINES.INVENTORY_ITEM_ID
AND UORG.USER_ID=ACC.USER_ID
AND MSI.ORGANIZATION_ID =UORG.ORGANIZATION_ID