VIEW: APPS.PO_REQUISITION_LINES_INQ_V

Source

View Text - Preformatted

SELECT PRL.ROWID , PRH.REQUISITION_HEADER_ID , PRL.REQUISITION_LINE_ID , PRL.LINE_NUM , PLTT.LINE_TYPE , PLTT.LINE_TYPE_ID , PRL.ITEM_ID , PRL.ITEM_REVISION , PRL.CATEGORY_ID , PRL.ITEM_DESCRIPTION , PRL.QUANTITY , decode(prl.order_type_lookup_code,'RATE',to_number(null),'FIXED PRICE', to_number(null),NVL(PRL.QUANTITY_RECEIVED,0)) , decode(prl.order_type_lookup_code,'RATE',to_number(null),'FIXED PRICE', to_number(null),NVL(PRL.QUANTITY_DELIVERED,0)) , decode(prl.order_type_lookup_code,'RATE',to_number(null),'FIXED PRICE', to_number(null),NVL(PRL.QUANTITY_CANCELLED,0)) , PRL.UNIT_MEAS_LOOKUP_CODE , PRL.UNIT_PRICE , PRL.NEED_BY_DATE , PRL.NOTE_TO_AGENT , PRL.SUGGESTED_VENDOR_NAME , PRL.SUGGESTED_VENDOR_LOCATION , PRL.SUGGESTED_VENDOR_CONTACT , PRL.SUGGESTED_VENDOR_PHONE , PRL.RFQ_REQUIRED_FLAG , NVL(PRL.ON_RFQ_FLAG,'N') , PRL.CANCEL_FLAG , PRL.MODIFIED_BY_AGENT_FLAG , POUN.UN_NUMBER , PHC.HAZARD_CLASS , NULL , PRL.REFERENCE_NUM , PRL.URGENT_FLAG , PRL.JUSTIFICATION , PRL.NOTE_TO_RECEIVER , PRL.ENCUMBERED_FLAG , PRL.DESTINATION_TYPE_CODE , PRL.SOURCE_TYPE_CODE , HOUT2.NAME , HRL1.LOCATION_CODE , PRL.DESTINATION_SUBINVENTORY , HOUT.NAME , PRL.SOURCE_SUBINVENTORY , PRL.ATTRIBUTE1 , PRL.ATTRIBUTE2 , PRL.ATTRIBUTE3 , PRL.ATTRIBUTE4 , PRL.ATTRIBUTE5 , PRL.ATTRIBUTE6 , PRL.ATTRIBUTE7 , PRL.ATTRIBUTE8 , PRL.ATTRIBUTE9 , PRL.ATTRIBUTE10 , PRL.ATTRIBUTE11 , PRL.ATTRIBUTE12 , PRL.ATTRIBUTE13 , PRL.ATTRIBUTE14 , PRL.ATTRIBUTE15 , PRL.ATTRIBUTE_CATEGORY , NVL(PLTB.OUTSIDE_OPERATION_FLAG, 'N') , PRL.DELIVER_TO_LOCATION_ID , PRL.TO_PERSON_ID , PRL.LAST_UPDATE_DATE , PRL.LAST_UPDATED_BY , PRL.LAST_UPDATE_LOGIN , PRL.CREATION_DATE , PRL.CREATED_BY , PRL.SUGGESTED_VENDOR_PRODUCT_CODE , PRL.UN_NUMBER_ID , PRL.HAZARD_CLASS_ID , NVL(PRL.CURRENCY_CODE, GSB.CURRENCY_CODE) , PRL.RATE , PRL.RATE_TYPE , PRL.RATE_DATE , PRL.CURRENCY_UNIT_PRICE , PRL.SUGGESTED_BUYER_ID , PRL.CLOSED_CODE , PRL.LINE_LOCATION_ID , PRL.PARENT_REQ_LINE_ID , PRL.PURCHASING_AGENT_ID , PRL.DOCUMENT_TYPE_CODE , PRL.BLANKET_PO_HEADER_ID , PRL.BLANKET_PO_LINE_NUM , PRL.CANCEL_REASON , PRL.CANCEL_DATE , PRL.AGENT_RETURN_NOTE , PRL.CHANGED_AFTER_RESEARCH_FLAG , PRL.VENDOR_ID , PRL.VENDOR_SITE_ID , PRL.VENDOR_CONTACT_ID , PRL.RESEARCH_AGENT_ID , PRL.ON_LINE_FLAG , PRL.WIP_ENTITY_ID , PRL.WIP_LINE_ID , PRL.WIP_REPETITIVE_SCHEDULE_ID , PRL.WIP_OPERATION_SEQ_NUM , PRL.WIP_RESOURCE_SEQ_NUM , WPE.WIP_ENTITY_NAME , WPL.LINE_CODE , BMR.RESOURCE_CODE , BMR.UNIT_OF_MEASURE , PRL.DESTINATION_CONTEXT , PRL.INVENTORY_SOURCE_CONTEXT , PRL.VENDOR_SOURCE_CONTEXT , PRL.BOM_RESOURCE_ID , PRL.USSGL_TRANSACTION_CODE , PRL.GOVERNMENT_CONTEXT , PRL.CLOSED_REASON , PRL.CLOSED_DATE , PRL.TRANSACTION_REASON_CODE , PRL.SOURCE_REQ_LINE_ID , PRL.DESTINATION_ORGANIZATION_ID , PRL.SOURCE_ORGANIZATION_ID , PLTB.ORDER_TYPE_LOOKUP_CODE , GDT.USER_CONVERSION_TYPE , MSI.STOCK_ENABLED_FLAG , NVL(MSI.INTERNAL_ORDER_ENABLED_FLAG,'N') , NVL(MSI.PURCHASING_ENABLED_FLAG,'N') , NVL(MSI.OUTSIDE_OPERATION_FLAG,'N') , MSI.INVENTORY_ASSET_FLAG , MUOM.UOM_CLASS , NULL , NULL , NULL , MSI.FULL_LEAD_TIME , POLA.CUSTOMER_ID , POLA.ADDRESS_ID , POLA.SITE_USE_ID , PRH.SEGMENT1 , PRH.PREPARER_ID , PRH.AUTHORIZATION_STATUS , NULL , PRH.TYPE_LOOKUP_CODE , PDTL.TYPE_NAME , PRH.INTERFACE_SOURCE_CODE , PRH.DESCRIPTION , PRH.EMERGENCY_PO_NUM , PRL.CATALOG_TYPE , PRL.CATALOG_SOURCE , PRL.MANUFACTURER_ID , PRL.MANUFACTURER_NAME , PRL.MANUFACTURER_PART_NUMBER , PRL.REQUESTER_EMAIL , PRL.REQUESTER_FAX , PRL.REQUESTER_PHONE , PRL.UNSPSC_CODE , PRL.OTHER_CATEGORY_CODE , PRL.SUPPLIER_DUNS , PRL.TAX_STATUS_INDICATOR , PRL.NEW_SUPPLIER_FLAG , PRL.AUTO_RECEIVE_FLAG , DECODE(NVL(PRL.PCARD_FLAG,'N'),'N',NULL,'S',-99999,PRH.PCARD_ID) PCARD_ID , NULL , PRL.TAX_CODE_ID , PRL.OKE_CONTRACT_HEADER_ID , PRL.OKE_CONTRACT_VERSION_ID , PRL.SECONDARY_UNIT_OF_MEASURE , PRL.SECONDARY_QUANTITY , PRL.PREFERRED_GRADE , PRL.SECONDARY_QUANTITY_RECEIVED , PRL.SECONDARY_QUANTITY_CANCELLED , PRL.AUCTION_HEADER_ID , PRL.AUCTION_DISPLAY_NUMBER , PRL.AUCTION_LINE_NUMBER , PRL.REQS_IN_POOL_FLAG , PRL.VMI_FLAG ,PRL.BID_NUMBER ,PRL.BID_LINE_NUMBER ,PRL.SUPPLIER_REF_NUMBER ,PRL.AMOUNT ,DECODE(PRL.CURRENCY_UNIT_PRICE, NULL, NULL, PRL.CURRENCY_UNIT_PRICE * PRL.QUANTITY) ,PRL.JOB_ID ,PRL.CANDIDATE_FIRST_NAME ,PRL.CANDIDATE_LAST_NAME ,PRL.ASSIGNMENT_END_DATE ,PRL.LABOR_REQ_LINE_ID ,PRL.CONTRACTOR_REQUISITION_FLAG ,PLTB.PURCHASE_BASIS , PRL.DROP_SHIP_FLAG ,PRL.ASSIGNMENT_START_DATE , PRL.ORG_ID , HOUTL3.NAME , HOUTL4.NAME , PRL.SUGGESTED_VENDOR_CONTACT_FAX , PRL.SUGGESTED_VENDOR_CONTACT_EMAIL , PRL.BASE_UNIT_PRICE , PRL.AT_SOURCING_FLAG , PRH.CONTRACTOR_STATUS , PODB.SECURITY_LEVEL_CODE FROM GL_SETS_OF_BOOKS GSB, FINANCIALS_SYSTEM_PARAMS_ALL FSP, PO_LINE_TYPES_TL PLTT, PO_LINE_TYPES_B PLTB, GL_DAILY_CONVERSION_TYPES GDT, PO_DOCUMENT_TYPES_ALL_TL PDTL, MTL_UNITS_OF_MEASURE MUOM, PO_LOCATION_ASSOCIATIONS_ALL POLA, PO_UN_NUMBERS_TL POUN, PO_HAZARD_CLASSES_TL PHC, HR_LOCATIONS_ALL_TL HRL1, HR_ALL_ORGANIZATION_UNITS_TL HOUT, HR_ALL_ORGANIZATION_UNITS_TL HOUT2, MTL_SYSTEM_ITEMS MSI, WIP_ENTITIES WPE, WIP_LINES WPL, BOM_RESOURCES BMR, PO_REQUISITION_HEADERS_ALL PRH, PO_REQUISITION_LINES PRL, HR_ALL_ORGANIZATION_UNITS_TL HOUTL3, HR_ALL_ORGANIZATION_UNITS_TL HOUTL4, PO_LINE_LOCATIONS_ALL POLL1, PO_DOCUMENT_TYPES_ALL_B PODB WHERE PRH.REQUISITION_HEADER_ID = PRL.REQUISITION_HEADER_ID AND ( (FSP.ORG_ID = PRH.ORG_ID AND FSP.ORG_ID = PRL.ORG_ID) OR (FSP.ORG_ID = POLL1.ORG_ID AND FSP.ORG_ID = PRL.ORG_ID) ) AND FSP.ORG_ID = PRL.ORG_ID AND POLL1.LINE_LOCATION_ID(+) = PRL.LINE_LOCATION_ID AND NVL(PRH.AUTHORIZATION_STATUS,'INCOMPLETE')<>'SYSTEM_SAVED' AND PLTB.LINE_TYPE_ID = PRL.LINE_TYPE_ID AND PLTB.LINE_TYPE_ID = PLTT.LINE_TYPE_ID AND PLTT.LANGUAGE = USERENV('LANG') AND POUN.UN_NUMBER_ID (+) = PRL.UN_NUMBER_ID AND POUN.LANGUAGE(+) = USERENV('LANG') AND PHC.HAZARD_CLASS_ID (+) = PRL.HAZARD_CLASS_ID AND PHC.LANGUAGE(+) = USERENV('LANG') AND HRL1.LOCATION_ID(+) = PRL.DELIVER_TO_LOCATION_ID AND HRL1.LANGUAGE(+) = USERENV('LANG') AND MSI.INVENTORY_ITEM_ID (+) = PRL.ITEM_ID AND MSI.ORGANIZATION_ID (+) = PRL.DESTINATION_ORGANIZATION_ID AND MUOM.UNIT_OF_MEASURE (+) = PRL.UNIT_MEAS_LOOKUP_CODE AND POLA.LOCATION_ID (+) = PRL.DELIVER_TO_LOCATION_ID AND POLA.ORG_ID(+) = PRL.ORG_ID AND GDT.CONVERSION_TYPE (+) = PRL.RATE_TYPE AND WPE.WIP_ENTITY_ID (+) = PRL.WIP_ENTITY_ID AND WPE.ORGANIZATION_ID (+) = PRL.DESTINATION_ORGANIZATION_ID AND WPL.LINE_ID (+) = PRL.WIP_LINE_ID AND WPL.ORGANIZATION_ID (+) = PRL.DESTINATION_ORGANIZATION_ID AND BMR.RESOURCE_ID (+) = PRL.BOM_RESOURCE_ID AND BMR.ORGANIZATION_ID (+) = PRL.DESTINATION_ORGANIZATION_ID AND PDTL.DOCUMENT_TYPE_CODE = 'REQUISITION' AND PDTL.DOCUMENT_SUBTYPE = PRH.TYPE_LOOKUP_CODE AND PDTL.LANGUAGE = USERENV('LANG') AND PDTL.ORG_ID = PRL.ORG_ID AND FSP.SET_OF_BOOKS_ID = GSB.SET_OF_BOOKS_ID AND HOUT.ORGANIZATION_ID(+) = PRL.SOURCE_ORGANIZATION_ID AND HOUT.LANGUAGE(+)= USERENV('LANG') AND HOUT2.ORGANIZATION_ID(+) = PRL.DESTINATION_ORGANIZATION_ID AND HOUT2.LANGUAGE(+) = USERENV('LANG') AND HOUTL3.ORGANIZATION_ID(+) = PRL.ORG_ID AND HOUTL3.LANGUAGE(+) = USERENV('LANG') AND HOUTL4.ORGANIZATION_ID(+) = POLL1.ORG_ID AND HOUTL4.LANGUAGE(+)= USERENV('LANG') AND PODB.DOCUMENT_TYPE_CODE = PDTL.DOCUMENT_TYPE_CODE AND PODB.DOCUMENT_SUBTYPE = PDTL.DOCUMENT_SUBTYPE AND PDTL.ORG_ID = PODB.ORG_ID AND Nvl(PRH.FEDERAL_FLAG,'N') = 'N'

View Text - HTML Formatted

SELECT PRL.ROWID
, PRH.REQUISITION_HEADER_ID
, PRL.REQUISITION_LINE_ID
, PRL.LINE_NUM
, PLTT.LINE_TYPE
, PLTT.LINE_TYPE_ID
, PRL.ITEM_ID
, PRL.ITEM_REVISION
, PRL.CATEGORY_ID
, PRL.ITEM_DESCRIPTION
, PRL.QUANTITY
, DECODE(PRL.ORDER_TYPE_LOOKUP_CODE
, 'RATE'
, TO_NUMBER(NULL)
, 'FIXED PRICE'
, TO_NUMBER(NULL)
, NVL(PRL.QUANTITY_RECEIVED
, 0))
, DECODE(PRL.ORDER_TYPE_LOOKUP_CODE
, 'RATE'
, TO_NUMBER(NULL)
, 'FIXED PRICE'
, TO_NUMBER(NULL)
, NVL(PRL.QUANTITY_DELIVERED
, 0))
, DECODE(PRL.ORDER_TYPE_LOOKUP_CODE
, 'RATE'
, TO_NUMBER(NULL)
, 'FIXED PRICE'
, TO_NUMBER(NULL)
, NVL(PRL.QUANTITY_CANCELLED
, 0))
, PRL.UNIT_MEAS_LOOKUP_CODE
, PRL.UNIT_PRICE
, PRL.NEED_BY_DATE
, PRL.NOTE_TO_AGENT
, PRL.SUGGESTED_VENDOR_NAME
, PRL.SUGGESTED_VENDOR_LOCATION
, PRL.SUGGESTED_VENDOR_CONTACT
, PRL.SUGGESTED_VENDOR_PHONE
, PRL.RFQ_REQUIRED_FLAG
, NVL(PRL.ON_RFQ_FLAG
, 'N')
, PRL.CANCEL_FLAG
, PRL.MODIFIED_BY_AGENT_FLAG
, POUN.UN_NUMBER
, PHC.HAZARD_CLASS
, NULL
, PRL.REFERENCE_NUM
, PRL.URGENT_FLAG
, PRL.JUSTIFICATION
, PRL.NOTE_TO_RECEIVER
, PRL.ENCUMBERED_FLAG
, PRL.DESTINATION_TYPE_CODE
, PRL.SOURCE_TYPE_CODE
, HOUT2.NAME
, HRL1.LOCATION_CODE
, PRL.DESTINATION_SUBINVENTORY
, HOUT.NAME
, PRL.SOURCE_SUBINVENTORY
, PRL.ATTRIBUTE1
, PRL.ATTRIBUTE2
, PRL.ATTRIBUTE3
, PRL.ATTRIBUTE4
, PRL.ATTRIBUTE5
, PRL.ATTRIBUTE6
, PRL.ATTRIBUTE7
, PRL.ATTRIBUTE8
, PRL.ATTRIBUTE9
, PRL.ATTRIBUTE10
, PRL.ATTRIBUTE11
, PRL.ATTRIBUTE12
, PRL.ATTRIBUTE13
, PRL.ATTRIBUTE14
, PRL.ATTRIBUTE15
, PRL.ATTRIBUTE_CATEGORY
, NVL(PLTB.OUTSIDE_OPERATION_FLAG
, 'N')
, PRL.DELIVER_TO_LOCATION_ID
, PRL.TO_PERSON_ID
, PRL.LAST_UPDATE_DATE
, PRL.LAST_UPDATED_BY
, PRL.LAST_UPDATE_LOGIN
, PRL.CREATION_DATE
, PRL.CREATED_BY
, PRL.SUGGESTED_VENDOR_PRODUCT_CODE
, PRL.UN_NUMBER_ID
, PRL.HAZARD_CLASS_ID
, NVL(PRL.CURRENCY_CODE
, GSB.CURRENCY_CODE)
, PRL.RATE
, PRL.RATE_TYPE
, PRL.RATE_DATE
, PRL.CURRENCY_UNIT_PRICE
, PRL.SUGGESTED_BUYER_ID
, PRL.CLOSED_CODE
, PRL.LINE_LOCATION_ID
, PRL.PARENT_REQ_LINE_ID
, PRL.PURCHASING_AGENT_ID
, PRL.DOCUMENT_TYPE_CODE
, PRL.BLANKET_PO_HEADER_ID
, PRL.BLANKET_PO_LINE_NUM
, PRL.CANCEL_REASON
, PRL.CANCEL_DATE
, PRL.AGENT_RETURN_NOTE
, PRL.CHANGED_AFTER_RESEARCH_FLAG
, PRL.VENDOR_ID
, PRL.VENDOR_SITE_ID
, PRL.VENDOR_CONTACT_ID
, PRL.RESEARCH_AGENT_ID
, PRL.ON_LINE_FLAG
, PRL.WIP_ENTITY_ID
, PRL.WIP_LINE_ID
, PRL.WIP_REPETITIVE_SCHEDULE_ID
, PRL.WIP_OPERATION_SEQ_NUM
, PRL.WIP_RESOURCE_SEQ_NUM
, WPE.WIP_ENTITY_NAME
, WPL.LINE_CODE
, BMR.RESOURCE_CODE
, BMR.UNIT_OF_MEASURE
, PRL.DESTINATION_CONTEXT
, PRL.INVENTORY_SOURCE_CONTEXT
, PRL.VENDOR_SOURCE_CONTEXT
, PRL.BOM_RESOURCE_ID
, PRL.USSGL_TRANSACTION_CODE
, PRL.GOVERNMENT_CONTEXT
, PRL.CLOSED_REASON
, PRL.CLOSED_DATE
, PRL.TRANSACTION_REASON_CODE
, PRL.SOURCE_REQ_LINE_ID
, PRL.DESTINATION_ORGANIZATION_ID
, PRL.SOURCE_ORGANIZATION_ID
, PLTB.ORDER_TYPE_LOOKUP_CODE
, GDT.USER_CONVERSION_TYPE
, MSI.STOCK_ENABLED_FLAG
, NVL(MSI.INTERNAL_ORDER_ENABLED_FLAG
, 'N')
, NVL(MSI.PURCHASING_ENABLED_FLAG
, 'N')
, NVL(MSI.OUTSIDE_OPERATION_FLAG
, 'N')
, MSI.INVENTORY_ASSET_FLAG
, MUOM.UOM_CLASS
, NULL
, NULL
, NULL
, MSI.FULL_LEAD_TIME
, POLA.CUSTOMER_ID
, POLA.ADDRESS_ID
, POLA.SITE_USE_ID
, PRH.SEGMENT1
, PRH.PREPARER_ID
, PRH.AUTHORIZATION_STATUS
, NULL
, PRH.TYPE_LOOKUP_CODE
, PDTL.TYPE_NAME
, PRH.INTERFACE_SOURCE_CODE
, PRH.DESCRIPTION
, PRH.EMERGENCY_PO_NUM
, PRL.CATALOG_TYPE
, PRL.CATALOG_SOURCE
, PRL.MANUFACTURER_ID
, PRL.MANUFACTURER_NAME
, PRL.MANUFACTURER_PART_NUMBER
, PRL.REQUESTER_EMAIL
, PRL.REQUESTER_FAX
, PRL.REQUESTER_PHONE
, PRL.UNSPSC_CODE
, PRL.OTHER_CATEGORY_CODE
, PRL.SUPPLIER_DUNS
, PRL.TAX_STATUS_INDICATOR
, PRL.NEW_SUPPLIER_FLAG
, PRL.AUTO_RECEIVE_FLAG
, DECODE(NVL(PRL.PCARD_FLAG
, 'N')
, 'N'
, NULL
, 'S'
, -99999
, PRH.PCARD_ID) PCARD_ID
, NULL
, PRL.TAX_CODE_ID
, PRL.OKE_CONTRACT_HEADER_ID
, PRL.OKE_CONTRACT_VERSION_ID
, PRL.SECONDARY_UNIT_OF_MEASURE
, PRL.SECONDARY_QUANTITY
, PRL.PREFERRED_GRADE
, PRL.SECONDARY_QUANTITY_RECEIVED
, PRL.SECONDARY_QUANTITY_CANCELLED
, PRL.AUCTION_HEADER_ID
, PRL.AUCTION_DISPLAY_NUMBER
, PRL.AUCTION_LINE_NUMBER
, PRL.REQS_IN_POOL_FLAG
, PRL.VMI_FLAG
, PRL.BID_NUMBER
, PRL.BID_LINE_NUMBER
, PRL.SUPPLIER_REF_NUMBER
, PRL.AMOUNT
, DECODE(PRL.CURRENCY_UNIT_PRICE
, NULL
, NULL
, PRL.CURRENCY_UNIT_PRICE * PRL.QUANTITY)
, PRL.JOB_ID
, PRL.CANDIDATE_FIRST_NAME
, PRL.CANDIDATE_LAST_NAME
, PRL.ASSIGNMENT_END_DATE
, PRL.LABOR_REQ_LINE_ID
, PRL.CONTRACTOR_REQUISITION_FLAG
, PLTB.PURCHASE_BASIS
, PRL.DROP_SHIP_FLAG
, PRL.ASSIGNMENT_START_DATE
, PRL.ORG_ID
, HOUTL3.NAME
, HOUTL4.NAME
, PRL.SUGGESTED_VENDOR_CONTACT_FAX
, PRL.SUGGESTED_VENDOR_CONTACT_EMAIL
, PRL.BASE_UNIT_PRICE
, PRL.AT_SOURCING_FLAG
, PRH.CONTRACTOR_STATUS
, PODB.SECURITY_LEVEL_CODE
FROM GL_SETS_OF_BOOKS GSB
, FINANCIALS_SYSTEM_PARAMS_ALL FSP
, PO_LINE_TYPES_TL PLTT
, PO_LINE_TYPES_B PLTB
, GL_DAILY_CONVERSION_TYPES GDT
, PO_DOCUMENT_TYPES_ALL_TL PDTL
, MTL_UNITS_OF_MEASURE MUOM
, PO_LOCATION_ASSOCIATIONS_ALL POLA
, PO_UN_NUMBERS_TL POUN
, PO_HAZARD_CLASSES_TL PHC
, HR_LOCATIONS_ALL_TL HRL1
, HR_ALL_ORGANIZATION_UNITS_TL HOUT
, HR_ALL_ORGANIZATION_UNITS_TL HOUT2
, MTL_SYSTEM_ITEMS MSI
, WIP_ENTITIES WPE
, WIP_LINES WPL
, BOM_RESOURCES BMR
, PO_REQUISITION_HEADERS_ALL PRH
, PO_REQUISITION_LINES PRL
, HR_ALL_ORGANIZATION_UNITS_TL HOUTL3
, HR_ALL_ORGANIZATION_UNITS_TL HOUTL4
, PO_LINE_LOCATIONS_ALL POLL1
, PO_DOCUMENT_TYPES_ALL_B PODB
WHERE PRH.REQUISITION_HEADER_ID = PRL.REQUISITION_HEADER_ID
AND ( (FSP.ORG_ID = PRH.ORG_ID
AND FSP.ORG_ID = PRL.ORG_ID) OR (FSP.ORG_ID = POLL1.ORG_ID
AND FSP.ORG_ID = PRL.ORG_ID) )
AND FSP.ORG_ID = PRL.ORG_ID
AND POLL1.LINE_LOCATION_ID(+) = PRL.LINE_LOCATION_ID
AND NVL(PRH.AUTHORIZATION_STATUS
, 'INCOMPLETE')<>'SYSTEM_SAVED'
AND PLTB.LINE_TYPE_ID = PRL.LINE_TYPE_ID
AND PLTB.LINE_TYPE_ID = PLTT.LINE_TYPE_ID
AND PLTT.LANGUAGE = USERENV('LANG')
AND POUN.UN_NUMBER_ID (+) = PRL.UN_NUMBER_ID
AND POUN.LANGUAGE(+) = USERENV('LANG')
AND PHC.HAZARD_CLASS_ID (+) = PRL.HAZARD_CLASS_ID
AND PHC.LANGUAGE(+) = USERENV('LANG')
AND HRL1.LOCATION_ID(+) = PRL.DELIVER_TO_LOCATION_ID
AND HRL1.LANGUAGE(+) = USERENV('LANG')
AND MSI.INVENTORY_ITEM_ID (+) = PRL.ITEM_ID
AND MSI.ORGANIZATION_ID (+) = PRL.DESTINATION_ORGANIZATION_ID
AND MUOM.UNIT_OF_MEASURE (+) = PRL.UNIT_MEAS_LOOKUP_CODE
AND POLA.LOCATION_ID (+) = PRL.DELIVER_TO_LOCATION_ID
AND POLA.ORG_ID(+) = PRL.ORG_ID
AND GDT.CONVERSION_TYPE (+) = PRL.RATE_TYPE
AND WPE.WIP_ENTITY_ID (+) = PRL.WIP_ENTITY_ID
AND WPE.ORGANIZATION_ID (+) = PRL.DESTINATION_ORGANIZATION_ID
AND WPL.LINE_ID (+) = PRL.WIP_LINE_ID
AND WPL.ORGANIZATION_ID (+) = PRL.DESTINATION_ORGANIZATION_ID
AND BMR.RESOURCE_ID (+) = PRL.BOM_RESOURCE_ID
AND BMR.ORGANIZATION_ID (+) = PRL.DESTINATION_ORGANIZATION_ID
AND PDTL.DOCUMENT_TYPE_CODE = 'REQUISITION'
AND PDTL.DOCUMENT_SUBTYPE = PRH.TYPE_LOOKUP_CODE
AND PDTL.LANGUAGE = USERENV('LANG')
AND PDTL.ORG_ID = PRL.ORG_ID
AND FSP.SET_OF_BOOKS_ID = GSB.SET_OF_BOOKS_ID
AND HOUT.ORGANIZATION_ID(+) = PRL.SOURCE_ORGANIZATION_ID
AND HOUT.LANGUAGE(+)= USERENV('LANG')
AND HOUT2.ORGANIZATION_ID(+) = PRL.DESTINATION_ORGANIZATION_ID
AND HOUT2.LANGUAGE(+) = USERENV('LANG')
AND HOUTL3.ORGANIZATION_ID(+) = PRL.ORG_ID
AND HOUTL3.LANGUAGE(+) = USERENV('LANG')
AND HOUTL4.ORGANIZATION_ID(+) = POLL1.ORG_ID
AND HOUTL4.LANGUAGE(+)= USERENV('LANG')
AND PODB.DOCUMENT_TYPE_CODE = PDTL.DOCUMENT_TYPE_CODE
AND PODB.DOCUMENT_SUBTYPE = PDTL.DOCUMENT_SUBTYPE
AND PDTL.ORG_ID = PODB.ORG_ID
AND NVL(PRH.FEDERAL_FLAG
, 'N') = 'N'