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.

VIEW: APPS.EAM_WO_REQ_PO_LITE_V

Source

View Text - Preformatted


SELECT pd.wip_entity_id, pd.wip_operation_seq_num, pd.destination_organization_id, rqh.segment1 req_number, poh.segment1 po_number, nvl (pd.item_description,rql.item_description) item_description, nvl(uom.uom_code,rqluom.uom_code) uom_code, nvl(pd.unit_price,rql.unit_price) unit_price, nvl(poh.currency_code,rql.currency_code) currency_code, rql.quantity req_line_qty, ( CASE WHEN (upper(rqh.authorization_status) IN('REJECTED','SYSTEM_SAVED','CANCELLED')) THEN rql.quantity WHEN (upper(rqh.authorization_status) = 'APPROVED' AND rql.cancel_flag = 'Y') THEN rql.quantity ELSE 0 END) req_line_qty_cancelled , pd.quantity po_line_qty, sum(pd.quantity_delivered ) quantity_received, sum(pd.quantity_ordered)-sum(pd.quantity_cancelled) po_quantity_ordered, sum(pd.quantity_cancelled) po_quantity_cancelled, pd.item_id, pd.wip_resource_seq_num , decode(poh.vendor_id, null, rql.vendor_id, poh.vendor_id ) vendor_id, rql.suggested_vendor_name, rql.requisition_line_id, rqh.requisition_header_id, poh.po_header_id, pd.po_release_id, nvl(pd.category_id,rql.category_id) category_id, nvl(polloc.need_by_date, rql.need_by_date) need_by_date, nvl(pd.order_type_lookup_code, rql.order_type_lookup_code) order_type_lookup_code, DECODE ( pd.order_type_lookup_code,NULL,sum(rql.amount),sum(pd.amount_ordered) ) amount, sum(pd.amount_delivered) amount_delivered, sum( rql.amount) rql_amount_ordered, sum(pd.amount_ordered) po_amount_ordered, CASE WHEN (rqh.authorization_status = 'APPROVED' AND rql.cancel_flag ='Y') THEN 'CANCELLED' ELSE rqh.authorization_status END requisition_status, CASE WHEN ( poh.authorization_status IS NULL AND poh.po_header_id IS NOT NULL ) THEN 'INCOMPLETE' WHEN (poh.authorization_status = 'APPROVED' AND pd.cancel_flag ='Y') THEN 'CANCELLED' WHEN (poh.authorization_status = 'APPROVED' and pd. closed_flag ='Y') THEN 'CLOSED' ELSE poh.authorization_status END po_status FROM po_line_types plt, po_headers_all poh, po_line_locations_all polloc, po_requisition_headers_all rqh, po_requisition_lines_all rql, mtl_units_of_measure uom, mtl_units_of_measure rqluom, ( SELECT pd1.wip_entity_id, pd1.wip_operation_seq_num, pd1.destination_organization_id, pol.item_description, pol.unit_price, pol.quantity , pd1.quantity_delivered, pd1.quantity_ordered, pd1.quantity_cancelled, pol.item_id, pd1.wip_resource_seq_num, pol.vendor_product_num, pd1.po_line_id, pd1.po_release_id, pol.category_id, pol.order_type_lookup_code, pd1.amount_ordered, pd1.amount_delivered, pd1.po_header_id, pd1.line_location_id, pol.unit_meas_lookup_code, pol.line_type_id, pd1.destination_type_code, pol.cancel_flag, pol.closed_flag FROM po_lines_all pol, po_distributions_all pd1 where pol.po_line_id = pd1.po_line_id AND( pd1.PO_RELEASE_ID IS NOT NULL OR pd1.DISTRIBUTION_TYPE = 'STANDARD') )pd WHERE poh.po_header_id = pd.po_header_id (+) AND rql.requisition_header_id = rqh.requisition_header_id(+) AND polloc.po_line_id = pd.po_line_id AND polloc.line_location_id = pd.line_location_id AND pd.line_location_id = rql.line_location_id (+) AND pd.wip_entity_id = rql.wip_entity_id (+) AND pd.wip_operation_seq_num = rql.wip_operation_seq_num (+) AND pd.unit_meas_lookup_code = uom.unit_of_measure (+) AND rql.unit_meas_lookup_code = rqluom.unit_of_measure (+) AND pd.line_type_id = plt.line_type_id AND upper(nvl(plt.outside_operation_flag, 'N')) = 'N' AND pd.destination_type_code = 'SHOP FLOOR' AND pd.wip_entity_id is not null AND nvl(rql.modified_by_agent_flag,'N') <> 'Y' GROUP BY pd.wip_entity_id, pd.wip_operation_seq_num, pd.destination_organization_id, rqh.segment1 , poh.segment1 , pd.item_description, rql.item_description, uom.uom_code, rqluom.uom_code, pd.category_id, rql.category_id , pd.order_type_lookup_code, rql.order_type_lookup_code, rql.unit_price, pd.unit_price, polloc.need_by_date, rql.need_by_date, rql.currency_code, poh.currency_code, rql.quantity , pd.quantity, pd.item_id, pd.wip_resource_seq_num, rql.vendor_id, poh.vendor_id, rql.suggested_vendor_name, rql.requisition_line_id, rqh.requisition_header_id, poh.po_header_id, pd.po_release_id, rqh.authorization_status, rql.cancel_flag, pd.cancel_flag, pd.closed_flag, poh.authorization_status UNION select rql.wip_entity_id, rql.wip_operation_seq_num, rql.destination_organization_id, rqh.segment1 req_number, poh.segment1 po_number, nvl(pd.item_description,rql.item_description ), nvl(uom.uom_code,rqluom.uom_code), nvl(pd.unit_price,rql.unit_price), nvl(poh.currency_code,rql.currency_code), rql.quantity req_line_qty, ( CASE WHEN (upper(rqh.authorization_status) IN('REJECTED','SYSTEM_SAVED','CANCELLED')) THEN rql.quantity WHEN (upper(rqh.authorization_status) = 'APPROVED' AND rql.cancel_flag = 'Y') THEN rql.quantity ELSE 0 END) req_line_qty_cancelled , pd.quantity po_line_qty, sum(pd.quantity_delivered) quantity_received, sum(pd.quantity_ordered)-sum(pd.quantity_cancelled) po_quantity_ordered, sum(pd.quantity_cancelled) po_quantity_cancelled, rql.item_id, rql.wip_resource_seq_num, decode(poh.vendor_id, null,rql.vendor_id, poh.vendor_id), rql.suggested_vendor_name, rql.requisition_line_id, rqh.requisition_header_id, poh.po_header_id, pd.po_release_id, nvl(pd.category_id,rql.category_id) , nvl(polloc.need_by_date, rql.need_by_date), nvl(pd.order_type_lookup_code , rql.order_type_lookup_code), DECODE ( pd.order_type_lookup_code, NULL, sum( rql.amount),sum(pd.amount_ordered)), sum(pd.amount_delivered ) amount_delivered, sum(rql.amount) rql_amount_ordered, sum(pd.amount_ordered) po_amount_ordered, CASE WHEN ( rqh.authorization_status = 'APPROVED' AND rql.cancel_flag ='Y' ) THEN 'CANCELLED' ELSE rqh.authorization_status END requisition_status, CASE WHEN ( poh.authorization_status IS NULL AND poh.po_header_id IS NOT NULL ) THEN 'INCOMPLETE' WHEN (poh.authorization_status = 'APPROVED' AND pd.cancel_flag ='Y') THEN 'CANCELLED' WHEN (poh.authorization_status = 'APPROVED ' and pd.closed_flag ='Y') THEN 'CLOSED' ELSE poh.authorization_status END po_status FROM po_line_types plt, po_headers_all poh, po_line_locations_all polloc, po_requisition_headers_all rqh, po_requisition_lines_all rql, mtl_units_of_measure uom, mtl_units_of_measure rqluom, ( select pd1.po_header_id , pd1.po_line_id, pol.unit_meas_lookup_code, pol.item_description, pol.category_id, pol.order_type_lookup_code, pol.unit_price, pol.quantity , pd1.po_release_id, pd1.line_location_id, pol.vendor_product_num, pd1.quantity_delivered, pd1.quantity_ordered, pd1.quantity_cancelled, pd1.amount_ordered, pd1.amount_delivered, pol.cancel_flag, pol.closed_flag, pd1.wip_entity_id, pd1.wip_operation_seq_num from po_lines_all pol, po_distributions_all pd1 where pol.po_line_id = pd1.po_line_id AND( pd1.PO_RELEASE_ID IS NOT NULL OR pd1.DISTRIBUTION_TYPE = 'STANDARD') ) pd WHERE pd.po_header_id = poh.po_header_id(+) AND rql.requisition_header_id = rqh.requisition_header_id (+) AND rql.line_location_id = pd.line_location_id (+) AND pd.po_line_id = polloc.po_line_id (+) AND pd.line_location_id = polloc.line_location_id (+) AND rql.wip_entity_id =pd.wip_entity_id (+) AND rql.wip_operation_seq_num =pd.wip_operation_seq_num (+) AND pd.unit_meas_lookup_code = uom.unit_of_measure (+) AND rql.unit_meas_lookup_code = rqluom.unit_of_measure(+) AND rql.line_type_id = plt.line_type_id AND upper(nvl(plt.outside_operation_flag, 'N') ) = 'N'AND rql.destination_type_code = 'SHOP FLOOR' AND upper(nvl(rqh.cancel_flag, 'N')) <> 'Y' AND rql.wip_entity_id is not null AND NVL(rql.modified_by_agent_flag,'N') <> 'Y' AND rqh.authorization_status NOT IN ('SYSTEM_SAVED') GROUP BY rql.wip_entity_id, rql.wip_operation_seq_num, rql.destination_organization_id, rqh.segment1 , poh.segment1, pd.item_description, rql.item_description, rqluom.uom_code, uom.uom_code, pd.category_id, rql.category_id, pd.order_type_lookup_code, rql.order_type_lookup_code, rql.unit_price, pd.unit_price, polloc.need_by_date, rql.need_by_date, rql.currency_code, poh.currency_code, rql.quantity , pd.quantity , rql.item_id, rql.wip_resource_seq_num, rql.vendor_id,poh.vendor_id, rql.suggested_vendor_name, rql.requisition_line_id, rqh.requisition_header_id, poh.po_header_id, pd.po_release_id , rqh.authorization_status, rql.cancel_flag, pd.cancel_flag, pd.closed_flag, poh.authorization_status

View Text - HTML Formatted

SELECT PD.WIP_ENTITY_ID
, PD.WIP_OPERATION_SEQ_NUM
, PD.DESTINATION_ORGANIZATION_ID
, RQH.SEGMENT1 REQ_NUMBER
, POH.SEGMENT1 PO_NUMBER
, NVL (PD.ITEM_DESCRIPTION
, RQL.ITEM_DESCRIPTION) ITEM_DESCRIPTION
, NVL(UOM.UOM_CODE
, RQLUOM.UOM_CODE) UOM_CODE
, NVL(PD.UNIT_PRICE
, RQL.UNIT_PRICE) UNIT_PRICE
, NVL(POH.CURRENCY_CODE
, RQL.CURRENCY_CODE) CURRENCY_CODE
, RQL.QUANTITY REQ_LINE_QTY
, ( CASE WHEN (UPPER(RQH.AUTHORIZATION_STATUS) IN('REJECTED'
, 'SYSTEM_SAVED'
, 'CANCELLED')) THEN RQL.QUANTITY WHEN (UPPER(RQH.AUTHORIZATION_STATUS) = 'APPROVED'
AND RQL.CANCEL_FLAG = 'Y') THEN RQL.QUANTITY ELSE 0 END) REQ_LINE_QTY_CANCELLED
, PD.QUANTITY PO_LINE_QTY
, SUM(PD.QUANTITY_DELIVERED ) QUANTITY_RECEIVED
, SUM(PD.QUANTITY_ORDERED)-SUM(PD.QUANTITY_CANCELLED) PO_QUANTITY_ORDERED
, SUM(PD.QUANTITY_CANCELLED) PO_QUANTITY_CANCELLED
, PD.ITEM_ID
, PD.WIP_RESOURCE_SEQ_NUM
, DECODE(POH.VENDOR_ID
, NULL
, RQL.VENDOR_ID
, POH.VENDOR_ID ) VENDOR_ID
, RQL.SUGGESTED_VENDOR_NAME
, RQL.REQUISITION_LINE_ID
, RQH.REQUISITION_HEADER_ID
, POH.PO_HEADER_ID
, PD.PO_RELEASE_ID
, NVL(PD.CATEGORY_ID
, RQL.CATEGORY_ID) CATEGORY_ID
, NVL(POLLOC.NEED_BY_DATE
, RQL.NEED_BY_DATE) NEED_BY_DATE
, NVL(PD.ORDER_TYPE_LOOKUP_CODE
, RQL.ORDER_TYPE_LOOKUP_CODE) ORDER_TYPE_LOOKUP_CODE
, DECODE ( PD.ORDER_TYPE_LOOKUP_CODE
, NULL
, SUM(RQL.AMOUNT)
, SUM(PD.AMOUNT_ORDERED) ) AMOUNT
, SUM(PD.AMOUNT_DELIVERED) AMOUNT_DELIVERED
, SUM( RQL.AMOUNT) RQL_AMOUNT_ORDERED
, SUM(PD.AMOUNT_ORDERED) PO_AMOUNT_ORDERED
, CASE WHEN (RQH.AUTHORIZATION_STATUS = 'APPROVED'
AND RQL.CANCEL_FLAG ='Y') THEN 'CANCELLED' ELSE RQH.AUTHORIZATION_STATUS END REQUISITION_STATUS
, CASE WHEN ( POH.AUTHORIZATION_STATUS IS NULL
AND POH.PO_HEADER_ID IS NOT NULL ) THEN 'INCOMPLETE' WHEN (POH.AUTHORIZATION_STATUS = 'APPROVED'
AND PD.CANCEL_FLAG ='Y') THEN 'CANCELLED' WHEN (POH.AUTHORIZATION_STATUS = 'APPROVED'
AND PD. CLOSED_FLAG ='Y') THEN 'CLOSED' ELSE POH.AUTHORIZATION_STATUS END PO_STATUS
FROM PO_LINE_TYPES PLT
, PO_HEADERS_ALL POH
, PO_LINE_LOCATIONS_ALL POLLOC
, PO_REQUISITION_HEADERS_ALL RQH
, PO_REQUISITION_LINES_ALL RQL
, MTL_UNITS_OF_MEASURE UOM
, MTL_UNITS_OF_MEASURE RQLUOM
, ( SELECT PD1.WIP_ENTITY_ID
, PD1.WIP_OPERATION_SEQ_NUM
, PD1.DESTINATION_ORGANIZATION_ID
, POL.ITEM_DESCRIPTION
, POL.UNIT_PRICE
, POL.QUANTITY
, PD1.QUANTITY_DELIVERED
, PD1.QUANTITY_ORDERED
, PD1.QUANTITY_CANCELLED
, POL.ITEM_ID
, PD1.WIP_RESOURCE_SEQ_NUM
, POL.VENDOR_PRODUCT_NUM
, PD1.PO_LINE_ID
, PD1.PO_RELEASE_ID
, POL.CATEGORY_ID
, POL.ORDER_TYPE_LOOKUP_CODE
, PD1.AMOUNT_ORDERED
, PD1.AMOUNT_DELIVERED
, PD1.PO_HEADER_ID
, PD1.LINE_LOCATION_ID
, POL.UNIT_MEAS_LOOKUP_CODE
, POL.LINE_TYPE_ID
, PD1.DESTINATION_TYPE_CODE
, POL.CANCEL_FLAG
, POL.CLOSED_FLAG
FROM PO_LINES_ALL POL
, PO_DISTRIBUTIONS_ALL PD1
WHERE POL.PO_LINE_ID = PD1.PO_LINE_ID AND( PD1.PO_RELEASE_ID IS NOT NULL OR PD1.DISTRIBUTION_TYPE = 'STANDARD') )PD
WHERE POH.PO_HEADER_ID = PD.PO_HEADER_ID (+)
AND RQL.REQUISITION_HEADER_ID = RQH.REQUISITION_HEADER_ID(+)
AND POLLOC.PO_LINE_ID = PD.PO_LINE_ID
AND POLLOC.LINE_LOCATION_ID = PD.LINE_LOCATION_ID
AND PD.LINE_LOCATION_ID = RQL.LINE_LOCATION_ID (+)
AND PD.WIP_ENTITY_ID = RQL.WIP_ENTITY_ID (+)
AND PD.WIP_OPERATION_SEQ_NUM = RQL.WIP_OPERATION_SEQ_NUM (+)
AND PD.UNIT_MEAS_LOOKUP_CODE = UOM.UNIT_OF_MEASURE (+)
AND RQL.UNIT_MEAS_LOOKUP_CODE = RQLUOM.UNIT_OF_MEASURE (+)
AND PD.LINE_TYPE_ID = PLT.LINE_TYPE_ID
AND UPPER(NVL(PLT.OUTSIDE_OPERATION_FLAG
, 'N')) = 'N'
AND PD.DESTINATION_TYPE_CODE = 'SHOP FLOOR'
AND PD.WIP_ENTITY_ID IS NOT NULL
AND NVL(RQL.MODIFIED_BY_AGENT_FLAG
, 'N') <> 'Y' GROUP BY PD.WIP_ENTITY_ID
, PD.WIP_OPERATION_SEQ_NUM
, PD.DESTINATION_ORGANIZATION_ID
, RQH.SEGMENT1
, POH.SEGMENT1
, PD.ITEM_DESCRIPTION
, RQL.ITEM_DESCRIPTION
, UOM.UOM_CODE
, RQLUOM.UOM_CODE
, PD.CATEGORY_ID
, RQL.CATEGORY_ID
, PD.ORDER_TYPE_LOOKUP_CODE
, RQL.ORDER_TYPE_LOOKUP_CODE
, RQL.UNIT_PRICE
, PD.UNIT_PRICE
, POLLOC.NEED_BY_DATE
, RQL.NEED_BY_DATE
, RQL.CURRENCY_CODE
, POH.CURRENCY_CODE
, RQL.QUANTITY
, PD.QUANTITY
, PD.ITEM_ID
, PD.WIP_RESOURCE_SEQ_NUM
, RQL.VENDOR_ID
, POH.VENDOR_ID
, RQL.SUGGESTED_VENDOR_NAME
, RQL.REQUISITION_LINE_ID
, RQH.REQUISITION_HEADER_ID
, POH.PO_HEADER_ID
, PD.PO_RELEASE_ID
, RQH.AUTHORIZATION_STATUS
, RQL.CANCEL_FLAG
, PD.CANCEL_FLAG
, PD.CLOSED_FLAG
, POH.AUTHORIZATION_STATUS UNION SELECT RQL.WIP_ENTITY_ID
, RQL.WIP_OPERATION_SEQ_NUM
, RQL.DESTINATION_ORGANIZATION_ID
, RQH.SEGMENT1 REQ_NUMBER
, POH.SEGMENT1 PO_NUMBER
, NVL(PD.ITEM_DESCRIPTION
, RQL.ITEM_DESCRIPTION )
, NVL(UOM.UOM_CODE
, RQLUOM.UOM_CODE)
, NVL(PD.UNIT_PRICE
, RQL.UNIT_PRICE)
, NVL(POH.CURRENCY_CODE
, RQL.CURRENCY_CODE)
, RQL.QUANTITY REQ_LINE_QTY
, ( CASE WHEN (UPPER(RQH.AUTHORIZATION_STATUS) IN('REJECTED'
, 'SYSTEM_SAVED'
, 'CANCELLED')) THEN RQL.QUANTITY WHEN (UPPER(RQH.AUTHORIZATION_STATUS) = 'APPROVED'
AND RQL.CANCEL_FLAG = 'Y') THEN RQL.QUANTITY ELSE 0 END) REQ_LINE_QTY_CANCELLED
, PD.QUANTITY PO_LINE_QTY
, SUM(PD.QUANTITY_DELIVERED) QUANTITY_RECEIVED
, SUM(PD.QUANTITY_ORDERED)-SUM(PD.QUANTITY_CANCELLED) PO_QUANTITY_ORDERED
, SUM(PD.QUANTITY_CANCELLED) PO_QUANTITY_CANCELLED
, RQL.ITEM_ID
, RQL.WIP_RESOURCE_SEQ_NUM
, DECODE(POH.VENDOR_ID
, NULL
, RQL.VENDOR_ID
, POH.VENDOR_ID)
, RQL.SUGGESTED_VENDOR_NAME
, RQL.REQUISITION_LINE_ID
, RQH.REQUISITION_HEADER_ID
, POH.PO_HEADER_ID
, PD.PO_RELEASE_ID
, NVL(PD.CATEGORY_ID
, RQL.CATEGORY_ID)
, NVL(POLLOC.NEED_BY_DATE
, RQL.NEED_BY_DATE)
, NVL(PD.ORDER_TYPE_LOOKUP_CODE
, RQL.ORDER_TYPE_LOOKUP_CODE)
, DECODE ( PD.ORDER_TYPE_LOOKUP_CODE
, NULL
, SUM( RQL.AMOUNT)
, SUM(PD.AMOUNT_ORDERED))
, SUM(PD.AMOUNT_DELIVERED ) AMOUNT_DELIVERED
, SUM(RQL.AMOUNT) RQL_AMOUNT_ORDERED
, SUM(PD.AMOUNT_ORDERED) PO_AMOUNT_ORDERED
, CASE WHEN ( RQH.AUTHORIZATION_STATUS = 'APPROVED'
AND RQL.CANCEL_FLAG ='Y' ) THEN 'CANCELLED' ELSE RQH.AUTHORIZATION_STATUS END REQUISITION_STATUS
, CASE WHEN ( POH.AUTHORIZATION_STATUS IS NULL
AND POH.PO_HEADER_ID IS NOT NULL ) THEN 'INCOMPLETE' WHEN (POH.AUTHORIZATION_STATUS = 'APPROVED'
AND PD.CANCEL_FLAG ='Y') THEN 'CANCELLED' WHEN (POH.AUTHORIZATION_STATUS = 'APPROVED '
AND PD.CLOSED_FLAG ='Y') THEN 'CLOSED' ELSE POH.AUTHORIZATION_STATUS END PO_STATUS
FROM PO_LINE_TYPES PLT
, PO_HEADERS_ALL POH
, PO_LINE_LOCATIONS_ALL POLLOC
, PO_REQUISITION_HEADERS_ALL RQH
, PO_REQUISITION_LINES_ALL RQL
, MTL_UNITS_OF_MEASURE UOM
, MTL_UNITS_OF_MEASURE RQLUOM
, ( SELECT PD1.PO_HEADER_ID
, PD1.PO_LINE_ID
, POL.UNIT_MEAS_LOOKUP_CODE
, POL.ITEM_DESCRIPTION
, POL.CATEGORY_ID
, POL.ORDER_TYPE_LOOKUP_CODE
, POL.UNIT_PRICE
, POL.QUANTITY
, PD1.PO_RELEASE_ID
, PD1.LINE_LOCATION_ID
, POL.VENDOR_PRODUCT_NUM
, PD1.QUANTITY_DELIVERED
, PD1.QUANTITY_ORDERED
, PD1.QUANTITY_CANCELLED
, PD1.AMOUNT_ORDERED
, PD1.AMOUNT_DELIVERED
, POL.CANCEL_FLAG
, POL.CLOSED_FLAG
, PD1.WIP_ENTITY_ID
, PD1.WIP_OPERATION_SEQ_NUM
FROM PO_LINES_ALL POL
, PO_DISTRIBUTIONS_ALL PD1
WHERE POL.PO_LINE_ID = PD1.PO_LINE_ID AND( PD1.PO_RELEASE_ID IS NOT NULL OR PD1.DISTRIBUTION_TYPE = 'STANDARD') ) PD
WHERE PD.PO_HEADER_ID = POH.PO_HEADER_ID(+)
AND RQL.REQUISITION_HEADER_ID = RQH.REQUISITION_HEADER_ID (+)
AND RQL.LINE_LOCATION_ID = PD.LINE_LOCATION_ID (+)
AND PD.PO_LINE_ID = POLLOC.PO_LINE_ID (+)
AND PD.LINE_LOCATION_ID = POLLOC.LINE_LOCATION_ID (+)
AND RQL.WIP_ENTITY_ID =PD.WIP_ENTITY_ID (+)
AND RQL.WIP_OPERATION_SEQ_NUM =PD.WIP_OPERATION_SEQ_NUM (+)
AND PD.UNIT_MEAS_LOOKUP_CODE = UOM.UNIT_OF_MEASURE (+)
AND RQL.UNIT_MEAS_LOOKUP_CODE = RQLUOM.UNIT_OF_MEASURE(+)
AND RQL.LINE_TYPE_ID = PLT.LINE_TYPE_ID
AND UPPER(NVL(PLT.OUTSIDE_OPERATION_FLAG
, 'N') ) = 'N'AND RQL.DESTINATION_TYPE_CODE = 'SHOP FLOOR'
AND UPPER(NVL(RQH.CANCEL_FLAG
, 'N')) <> 'Y'
AND RQL.WIP_ENTITY_ID IS NOT NULL
AND NVL(RQL.MODIFIED_BY_AGENT_FLAG
, 'N') <> 'Y'
AND RQH.AUTHORIZATION_STATUS NOT IN ('SYSTEM_SAVED') GROUP BY RQL.WIP_ENTITY_ID
, RQL.WIP_OPERATION_SEQ_NUM
, RQL.DESTINATION_ORGANIZATION_ID
, RQH.SEGMENT1
, POH.SEGMENT1
, PD.ITEM_DESCRIPTION
, RQL.ITEM_DESCRIPTION
, RQLUOM.UOM_CODE
, UOM.UOM_CODE
, PD.CATEGORY_ID
, RQL.CATEGORY_ID
, PD.ORDER_TYPE_LOOKUP_CODE
, RQL.ORDER_TYPE_LOOKUP_CODE
, RQL.UNIT_PRICE
, PD.UNIT_PRICE
, POLLOC.NEED_BY_DATE
, RQL.NEED_BY_DATE
, RQL.CURRENCY_CODE
, POH.CURRENCY_CODE
, RQL.QUANTITY
, PD.QUANTITY
, RQL.ITEM_ID
, RQL.WIP_RESOURCE_SEQ_NUM
, RQL.VENDOR_ID
, POH.VENDOR_ID
, RQL.SUGGESTED_VENDOR_NAME
, RQL.REQUISITION_LINE_ID
, RQH.REQUISITION_HEADER_ID
, POH.PO_HEADER_ID
, PD.PO_RELEASE_ID
, RQH.AUTHORIZATION_STATUS
, RQL.CANCEL_FLAG
, PD.CANCEL_FLAG
, PD.CLOSED_FLAG
, POH.AUTHORIZATION_STATUS