VIEW: APPS.PO_REQ_LINES_AUTOCREATE_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, PRL.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, PRL.CURRENCY_AMOUNT, 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, HOUTL3.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 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, PO_DOCUMENT_TYPES_ALL_B PODB WHERE PRH.REQUISITION_HEADER_ID = PRL.REQUISITION_HEADER_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 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 PODB.DOCUMENT_TYPE_CODE = PDTL.DOCUMENT_TYPE_CODE AND PODB.DOCUMENT_SUBTYPE = PDTL.DOCUMENT_SUBTYPE AND PDTL.ORG_ID = PODB.ORG_ID

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
, PRL.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
, PRL.CURRENCY_AMOUNT
, 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
, HOUTL3.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 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
, PO_DOCUMENT_TYPES_ALL_B PODB
WHERE PRH.REQUISITION_HEADER_ID = PRL.REQUISITION_HEADER_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 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 PODB.DOCUMENT_TYPE_CODE = PDTL.DOCUMENT_TYPE_CODE
AND PODB.DOCUMENT_SUBTYPE = PDTL.DOCUMENT_SUBTYPE
AND PDTL.ORG_ID = PODB.ORG_ID