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.PO_LINES_INQ_V

Source

View Text - Preformatted


SELECT POL.ROWID , POL.MARKET_PRICE , DECODE(POL.CANCEL_FLAG, 'I', NULL, POL.CANCEL_FLAG) , POL.CANCEL_DATE , NVL(POL.FIRM_STATUS_LOOKUP_CODE, 'N') , POL.CONTRACT_NUM , NULL , POL.PO_HEADER_ID , POL.LINE_NUM , POL.CREATION_DATE , POL.ITEM_REVISION , POL.UNIT_MEAS_LOOKUP_CODE UNIT_MEAS_LOOKUP_CODE , POL.COMMITTED_AMOUNT , POL.NOT_TO_EXCEED_PRICE , POL.QUANTITY , POL.HAZARD_CLASS_ID , POL.FROM_HEADER_ID , POL.PROGRAM_ID , POL.PROGRAM_UPDATE_DATE , POL.REQUEST_ID , POL.USSGL_TRANSACTION_CODE , POL.CLOSED_DATE , POL.CLOSED_REASON , POL.TRANSACTION_REASON_CODE , POL.CATEGORY_ID , POL.PRICE_TYPE_LOOKUP_CODE , POL.PRICE_BREAK_LOOKUP_CODE , POL.QTY_RCV_TOLERANCE , POL.TYPE_1099 , POL.CAPITAL_EXPENSE_FLAG , POL.NEGOTIATED_BY_PREPARER_FLAG , POL.MIN_RELEASE_AMOUNT , NVL(POL.CLOSED_CODE, 'OPEN') , POL.GOVERNMENT_CONTEXT , POL.PROGRAM_APPLICATION_ID , POL.MIN_ORDER_QUANTITY , POL.MAX_ORDER_QUANTITY , POL.OVER_TOLERANCE_ERROR_FLAG , POL.UNORDERED_FLAG , POL.CLOSED_FLAG , NVL(POL.USER_HOLD_FLAG, 'N') , POL.CANCEL_REASON , POL.FIRM_DATE , POL.VENDOR_PRODUCT_NUM , POL.TAXABLE_FLAG , POL.PO_LINE_ID , POL.LAST_UPDATE_DATE , POL.LAST_UPDATED_BY , POL.LINE_TYPE_ID , POL.LAST_UPDATE_LOGIN , POL.CREATED_BY , POL.ITEM_ID , POL.ITEM_DESCRIPTION , POL.QUANTITY_COMMITTED , POL.ALLOW_PRICE_OVERRIDE_FLAG , POL.LIST_PRICE_PER_UNIT , POL.UNIT_PRICE , POL.UN_NUMBER_ID , POL.NOTE_TO_VENDOR , POL.FROM_LINE_ID , POL.REFERENCE_NUM , POL.ATTRIBUTE_CATEGORY , POL.ATTRIBUTE1 , POL.ATTRIBUTE2 , POL.ATTRIBUTE3 , POL.ATTRIBUTE4 , POL.ATTRIBUTE5 , POL.ATTRIBUTE6 , POL.ATTRIBUTE7 , POL.ATTRIBUTE8 , POL.ATTRIBUTE9 , POL.ATTRIBUTE10 , POL.ATTRIBUTE11 , POL.ATTRIBUTE12 , POL.ATTRIBUTE13 , POL.ATTRIBUTE14 , POL.ATTRIBUTE15 , PLT.LINE_TYPE , PLT.ORDER_TYPE_LOOKUP_CODE , NVL(PLT.OUTSIDE_OPERATION_FLAG,'N') , MUOM.UOM_CLASS , POUNT.UN_NUMBER , PHCT.HAZARD_CLASS , NULL , NULL , NULL , NULL , POH2.QUOTE_VENDOR_QUOTE_NUMBER , POH.SEGMENT1 , POH.VENDOR_ID , POV.VENDOR_NAME , POH.VENDOR_SITE_ID , POVS.VENDOR_SITE_CODE , DECODE (POVC.LAST_NAME, NULL, NULL, POVC.LAST_NAME||', '|| POVC.FIRST_NAME) , POH.AGENT_ID , POH.BILL_TO_LOCATION_ID , HRL.LOCATION_CODE , POH.SHIP_TO_LOCATION_ID , HRL2.LOCATION_CODE , POH.CURRENCY_CODE , POH.TYPE_LOOKUP_CODE , POH.REVISION_NUM , PDTL.TYPE_NAME , NVL(POH.AUTHORIZATION_STATUS, 'INCOMPLETE') , NULL , POH.CREATION_DATE , POH.APPROVED_DATE , POH.REVISED_DATE , APT.NAME , POH.SHIP_VIA_LOOKUP_CODE , NULL , NULL , GLDC.USER_CONVERSION_TYPE , POH.RATE_DATE , POH.RATE , POH.START_DATE , POH.END_DATE , POH.BLANKET_TOTAL_AMOUNT , POH.NOTE_TO_RECEIVER , POH.CONFIRMING_ORDER_FLAG , POH.ACCEPTANCE_DUE_DATE , POL.closed_by , POL.cancelled_by , DECODE ( POH.TYPE_LOOKUP_CODE , 'STANDARD' ,TO_DATE( NULL) , POL.EXPIRATION_DATE ) , POL.TAX_CODE_ID ,POL.QC_GRADE ,POL.BASE_UOM ,POL.BASE_QTY ,POL.SECONDARY_UOM ,POL.SECONDARY_QTY ,POL.OKE_CONTRACT_HEADER_ID ,POL.OKE_CONTRACT_VERSION_ID ,POL.SECONDARY_UNIT_OF_MEASURE ,POL.SECONDARY_QUANTITY ,POL.PREFERRED_GRADE ,POH.FOB_LOOKUP_CODE ,POH.FREIGHT_TERMS_LOOKUP_CODE ,POL.AUCTION_HEADER_ID ,POL.AUCTION_DISPLAY_NUMBER ,POL.AUCTION_LINE_NUMBER ,POL.BID_NUMBER ,POL.BID_LINE_NUMBER ,POH.GLOBAL_AGREEMENT_FLAG ,POH.ENABLE_ALL_SITES ,POH.ORG_ID ,POH.ORG_ID ,POH.CONSIGNED_CONSUMPTION_FLAG ,POL.SUPPLIER_REF_NUMBER ,POL.CONTRACT_ID ,POL.JOB_ID ,POL.AMOUNT ,POL.START_DATE ,DECODE ( POH.TYPE_LOOKUP_CODE , 'STANDARD' , POL.EXPIRATION_DATE , NULL ) ,POL.CONTRACTOR_FIRST_NAME ,POL.CONTRACTOR_LAST_NAME ,PLT.PURCHASE_BASIS , HOUTL.NAME ,POL.FROM_LINE_LOCATION_ID ,POL.BASE_UNIT_PRICE ,DECODE (POH.TYPE_LOOKUP_CODE, 'STANDARD', (DECODE ( DECODE (POL.FROM_LINE_ID, NULL, DECODE (POL.CONTRACT_ID, NULL, 'no reference', 'contract'), 'GA or quotation'), 'no reference', NULL, DECODE (MANUAL_PRICE_CHANGE_FLAG, 'Y', 'N', 'Y') ))) ,POH.CONTERMS_EXIST_FLAG ,PDT.SECURITY_LEVEL_CODE ,POH.STYLE_ID FROM PO_LINES_ALL POL, PO_HEADERS_ALL POH, PO_HEADERS_ALL POH2, PO_VENDORS POV, PO_VENDOR_SITES_ALL POVS, PO_VENDOR_CONTACTS POVC, GL_DAILY_CONVERSION_TYPES GLDC, HR_LOCATIONS_ALL_TL HRL, HR_LOCATIONS_ALL_TL HRL2, AP_TERMS APT, PO_UN_NUMBERS_TL POUNT, PO_HAZARD_CLASSES_TL PHCT, PO_LINE_TYPES PLT, MTL_UNITS_OF_MEASURE MUOM, PO_DOCUMENT_TYPES_ALL_B PDT, PO_DOCUMENT_TYPES_ALL_TL PDTL, HR_ALL_ORGANIZATION_UNITS_TL HOUTL WHERE POH.PO_HEADER_ID = POL.PO_HEADER_ID AND ( ( NVL(POH.GLOBAL_AGREEMENT_FLAG,'N') = 'Y' AND ( (POH.ORG_ID IN (SELECT PSP.ORG_ID FROM PO_SYSTEM_PARAMETERS PSP)) OR ( EXISTS ( SELECT 'ENABLED IN CURRENT OU' FROM PO_GA_ORG_ASSIGNMENTS POGA WHERE POH.PO_HEADER_ID = POGA.PO_HEADER_ID AND POGA.ENABLED_FLAG ='Y' AND ( (POGA.ORGANIZATION_ID IN (SELECT PSP.ORG_ID FROM PO_SYSTEM_PARAMETERS PSP)) OR (POGA.PURCHASING_ORG_ID IN (SELECT PSP.ORG_ID FROM PO_SYSTEM_PARAMETERS PSP)) ) ) AND POH.AUTHORIZATION_STATUS = 'APPROVED' AND NVL(POH.CLOSED_CODE,'OPEN') <> 'FINALLY CLOSED' AND NVL(POH.CANCEL_FLAG,'N') = 'N' AND NVL(POH.FROZEN_FLAG,'N') = 'N' AND ( trunc(SYSDATE) BETWEEN NVL(trunc(POH.START_DATE), trunc(SYSDATE) -1) AND NVL(trunc(POH.END_DATE), trunc(SYSDATE)+1) OR ( TRUNC(POH.START_DATE) is not null AND SYSDATE <= POH.START_DATE ) ) AND trunc(sysdate) <= nvl(trunc(POL.expiration_date), trunc(sysdate)) AND NVL(POL.CLOSED_CODE,'OPEN') <> 'FINALLY CLOSED' AND NVL(POL.CANCEL_FLAG,'N') = 'N' ) ) ) OR ( NVL(POH.GLOBAL_AGREEMENT_FLAG,'N') = 'N' AND ( ( POL.ORG_ID IN (SELECT PSP.ORG_ID FROM PO_SYSTEM_PARAMETERS PSP)) OR EXISTS ( SELECT PRL.ORG_ID FROM PO_LINE_LOCATIONS_ALL PLL, PO_REQUISITION_LINES_ALL PRL, PO_SYSTEM_PARAMETERS PSP WHERE PRL.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID AND PLL.PO_LINE_ID = POL.PO_LINE_ID AND PSP.ORG_ID = PRL.ORG_ID ) ) ) ) AND PLT.LINE_TYPE_ID = POL.LINE_TYPE_ID AND MUOM.UNIT_OF_MEASURE (+) = POL.UNIT_MEAS_LOOKUP_CODE AND POUNT.UN_NUMBER_ID (+) = POL.UN_NUMBER_ID AND POUNT.LANGUAGE (+) = USERENV('LANG') AND PHCT.HAZARD_CLASS_ID (+) = POL.HAZARD_CLASS_ID AND PHCT.LANGUAGE (+) = USERENV('LANG') AND POH2.PO_HEADER_ID (+) = POL.FROM_HEADER_ID AND POV.VENDOR_ID (+) = POH.VENDOR_ID AND POVS.VENDOR_SITE_ID (+) = POH.VENDOR_SITE_ID AND POVC.VENDOR_CONTACT_ID (+) = POH.VENDOR_CONTACT_ID AND HRL.LOCATION_ID (+) = POH.BILL_TO_LOCATION_ID AND HRL.LANGUAGE (+) = USERENV('LANG') AND HRL2.LOCATION_ID (+) = POH.SHIP_TO_LOCATION_ID AND HRL2.LANGUAGE (+) = USERENV('LANG') AND PDT.DOCUMENT_TYPE_CODE IN ('PO', 'PA') AND PDT.DOCUMENT_SUBTYPE = POH.TYPE_LOOKUP_CODE AND PDTL.DOCUMENT_TYPE_CODE = PDT.DOCUMENT_TYPE_CODE AND PDTL.DOCUMENT_SUBTYPE = PDT.DOCUMENT_SUBTYPE AND PDTL.LANGUAGE = USERENV('LANG') AND PDT.ORG_ID = POH.ORG_ID AND PDTL.ORG_ID = PDT.ORG_ID AND APT.TERM_ID (+) = POH.TERMS_ID AND GLDC.CONVERSION_TYPE (+) = POH.RATE_TYPE AND HOUTL.ORGANIZATION_ID(+) = POH.ORG_ID AND HOUTL.LANGUAGE(+) = USERENV('LANG') AND ( POH.VENDOR_CONTACT_ID IS NULL OR POH.VENDOR_SITE_ID=POVC.VENDOR_SITE_ID )

View Text - HTML Formatted

SELECT POL.ROWID
, POL.MARKET_PRICE
, DECODE(POL.CANCEL_FLAG
, 'I'
, NULL
, POL.CANCEL_FLAG)
, POL.CANCEL_DATE
, NVL(POL.FIRM_STATUS_LOOKUP_CODE
, 'N')
, POL.CONTRACT_NUM
, NULL
, POL.PO_HEADER_ID
, POL.LINE_NUM
, POL.CREATION_DATE
, POL.ITEM_REVISION
, POL.UNIT_MEAS_LOOKUP_CODE UNIT_MEAS_LOOKUP_CODE
, POL.COMMITTED_AMOUNT
, POL.NOT_TO_EXCEED_PRICE
, POL.QUANTITY
, POL.HAZARD_CLASS_ID
, POL.FROM_HEADER_ID
, POL.PROGRAM_ID
, POL.PROGRAM_UPDATE_DATE
, POL.REQUEST_ID
, POL.USSGL_TRANSACTION_CODE
, POL.CLOSED_DATE
, POL.CLOSED_REASON
, POL.TRANSACTION_REASON_CODE
, POL.CATEGORY_ID
, POL.PRICE_TYPE_LOOKUP_CODE
, POL.PRICE_BREAK_LOOKUP_CODE
, POL.QTY_RCV_TOLERANCE
, POL.TYPE_1099
, POL.CAPITAL_EXPENSE_FLAG
, POL.NEGOTIATED_BY_PREPARER_FLAG
, POL.MIN_RELEASE_AMOUNT
, NVL(POL.CLOSED_CODE
, 'OPEN')
, POL.GOVERNMENT_CONTEXT
, POL.PROGRAM_APPLICATION_ID
, POL.MIN_ORDER_QUANTITY
, POL.MAX_ORDER_QUANTITY
, POL.OVER_TOLERANCE_ERROR_FLAG
, POL.UNORDERED_FLAG
, POL.CLOSED_FLAG
, NVL(POL.USER_HOLD_FLAG
, 'N')
, POL.CANCEL_REASON
, POL.FIRM_DATE
, POL.VENDOR_PRODUCT_NUM
, POL.TAXABLE_FLAG
, POL.PO_LINE_ID
, POL.LAST_UPDATE_DATE
, POL.LAST_UPDATED_BY
, POL.LINE_TYPE_ID
, POL.LAST_UPDATE_LOGIN
, POL.CREATED_BY
, POL.ITEM_ID
, POL.ITEM_DESCRIPTION
, POL.QUANTITY_COMMITTED
, POL.ALLOW_PRICE_OVERRIDE_FLAG
, POL.LIST_PRICE_PER_UNIT
, POL.UNIT_PRICE
, POL.UN_NUMBER_ID
, POL.NOTE_TO_VENDOR
, POL.FROM_LINE_ID
, POL.REFERENCE_NUM
, POL.ATTRIBUTE_CATEGORY
, POL.ATTRIBUTE1
, POL.ATTRIBUTE2
, POL.ATTRIBUTE3
, POL.ATTRIBUTE4
, POL.ATTRIBUTE5
, POL.ATTRIBUTE6
, POL.ATTRIBUTE7
, POL.ATTRIBUTE8
, POL.ATTRIBUTE9
, POL.ATTRIBUTE10
, POL.ATTRIBUTE11
, POL.ATTRIBUTE12
, POL.ATTRIBUTE13
, POL.ATTRIBUTE14
, POL.ATTRIBUTE15
, PLT.LINE_TYPE
, PLT.ORDER_TYPE_LOOKUP_CODE
, NVL(PLT.OUTSIDE_OPERATION_FLAG
, 'N')
, MUOM.UOM_CLASS
, POUNT.UN_NUMBER
, PHCT.HAZARD_CLASS
, NULL
, NULL
, NULL
, NULL
, POH2.QUOTE_VENDOR_QUOTE_NUMBER
, POH.SEGMENT1
, POH.VENDOR_ID
, POV.VENDOR_NAME
, POH.VENDOR_SITE_ID
, POVS.VENDOR_SITE_CODE
, DECODE (POVC.LAST_NAME
, NULL
, NULL
, POVC.LAST_NAME||'
, '|| POVC.FIRST_NAME)
, POH.AGENT_ID
, POH.BILL_TO_LOCATION_ID
, HRL.LOCATION_CODE
, POH.SHIP_TO_LOCATION_ID
, HRL2.LOCATION_CODE
, POH.CURRENCY_CODE
, POH.TYPE_LOOKUP_CODE
, POH.REVISION_NUM
, PDTL.TYPE_NAME
, NVL(POH.AUTHORIZATION_STATUS
, 'INCOMPLETE')
, NULL
, POH.CREATION_DATE
, POH.APPROVED_DATE
, POH.REVISED_DATE
, APT.NAME
, POH.SHIP_VIA_LOOKUP_CODE
, NULL
, NULL
, GLDC.USER_CONVERSION_TYPE
, POH.RATE_DATE
, POH.RATE
, POH.START_DATE
, POH.END_DATE
, POH.BLANKET_TOTAL_AMOUNT
, POH.NOTE_TO_RECEIVER
, POH.CONFIRMING_ORDER_FLAG
, POH.ACCEPTANCE_DUE_DATE
, POL.CLOSED_BY
, POL.CANCELLED_BY
, DECODE ( POH.TYPE_LOOKUP_CODE
, 'STANDARD'
, TO_DATE( NULL)
, POL.EXPIRATION_DATE )
, POL.TAX_CODE_ID
, POL.QC_GRADE
, POL.BASE_UOM
, POL.BASE_QTY
, POL.SECONDARY_UOM
, POL.SECONDARY_QTY
, POL.OKE_CONTRACT_HEADER_ID
, POL.OKE_CONTRACT_VERSION_ID
, POL.SECONDARY_UNIT_OF_MEASURE
, POL.SECONDARY_QUANTITY
, POL.PREFERRED_GRADE
, POH.FOB_LOOKUP_CODE
, POH.FREIGHT_TERMS_LOOKUP_CODE
, POL.AUCTION_HEADER_ID
, POL.AUCTION_DISPLAY_NUMBER
, POL.AUCTION_LINE_NUMBER
, POL.BID_NUMBER
, POL.BID_LINE_NUMBER
, POH.GLOBAL_AGREEMENT_FLAG
, POH.ENABLE_ALL_SITES
, POH.ORG_ID
, POH.ORG_ID
, POH.CONSIGNED_CONSUMPTION_FLAG
, POL.SUPPLIER_REF_NUMBER
, POL.CONTRACT_ID
, POL.JOB_ID
, POL.AMOUNT
, POL.START_DATE
, DECODE ( POH.TYPE_LOOKUP_CODE
, 'STANDARD'
, POL.EXPIRATION_DATE
, NULL )
, POL.CONTRACTOR_FIRST_NAME
, POL.CONTRACTOR_LAST_NAME
, PLT.PURCHASE_BASIS
, HOUTL.NAME
, POL.FROM_LINE_LOCATION_ID
, POL.BASE_UNIT_PRICE
, DECODE (POH.TYPE_LOOKUP_CODE
, 'STANDARD'
, (DECODE ( DECODE (POL.FROM_LINE_ID
, NULL
, DECODE (POL.CONTRACT_ID
, NULL
, 'NO REFERENCE'
, 'CONTRACT')
, 'GA OR QUOTATION')
, 'NO REFERENCE'
, NULL
, DECODE (MANUAL_PRICE_CHANGE_FLAG
, 'Y'
, 'N'
, 'Y') )))
, POH.CONTERMS_EXIST_FLAG
, PDT.SECURITY_LEVEL_CODE
, POH.STYLE_ID
FROM PO_LINES_ALL POL
, PO_HEADERS_ALL POH
, PO_HEADERS_ALL POH2
, PO_VENDORS POV
, PO_VENDOR_SITES_ALL POVS
, PO_VENDOR_CONTACTS POVC
, GL_DAILY_CONVERSION_TYPES GLDC
, HR_LOCATIONS_ALL_TL HRL
, HR_LOCATIONS_ALL_TL HRL2
, AP_TERMS APT
, PO_UN_NUMBERS_TL POUNT
, PO_HAZARD_CLASSES_TL PHCT
, PO_LINE_TYPES PLT
, MTL_UNITS_OF_MEASURE MUOM
, PO_DOCUMENT_TYPES_ALL_B PDT
, PO_DOCUMENT_TYPES_ALL_TL PDTL
, HR_ALL_ORGANIZATION_UNITS_TL HOUTL
WHERE POH.PO_HEADER_ID = POL.PO_HEADER_ID
AND ( ( NVL(POH.GLOBAL_AGREEMENT_FLAG
, 'N') = 'Y'
AND ( (POH.ORG_ID IN (SELECT PSP.ORG_ID
FROM PO_SYSTEM_PARAMETERS PSP)) OR ( EXISTS ( SELECT 'ENABLED IN CURRENT OU'
FROM PO_GA_ORG_ASSIGNMENTS POGA
WHERE POH.PO_HEADER_ID = POGA.PO_HEADER_ID
AND POGA.ENABLED_FLAG ='Y'
AND ( (POGA.ORGANIZATION_ID IN (SELECT PSP.ORG_ID
FROM PO_SYSTEM_PARAMETERS PSP)) OR (POGA.PURCHASING_ORG_ID IN (SELECT PSP.ORG_ID
FROM PO_SYSTEM_PARAMETERS PSP)) ) )
AND POH.AUTHORIZATION_STATUS = 'APPROVED'
AND NVL(POH.CLOSED_CODE
, 'OPEN') <> 'FINALLY CLOSED'
AND NVL(POH.CANCEL_FLAG
, 'N') = 'N'
AND NVL(POH.FROZEN_FLAG
, 'N') = 'N'
AND ( TRUNC(SYSDATE) BETWEEN NVL(TRUNC(POH.START_DATE)
, TRUNC(SYSDATE) -1)
AND NVL(TRUNC(POH.END_DATE)
, TRUNC(SYSDATE)+1) OR ( TRUNC(POH.START_DATE) IS NOT NULL
AND SYSDATE <= POH.START_DATE ) )
AND TRUNC(SYSDATE) <= NVL(TRUNC(POL.EXPIRATION_DATE)
, TRUNC(SYSDATE))
AND NVL(POL.CLOSED_CODE
, 'OPEN') <> 'FINALLY CLOSED'
AND NVL(POL.CANCEL_FLAG
, 'N') = 'N' ) ) ) OR ( NVL(POH.GLOBAL_AGREEMENT_FLAG
, 'N') = 'N'
AND ( ( POL.ORG_ID IN (SELECT PSP.ORG_ID
FROM PO_SYSTEM_PARAMETERS PSP)) OR EXISTS ( SELECT PRL.ORG_ID
FROM PO_LINE_LOCATIONS_ALL PLL
, PO_REQUISITION_LINES_ALL PRL
, PO_SYSTEM_PARAMETERS PSP
WHERE PRL.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID
AND PLL.PO_LINE_ID = POL.PO_LINE_ID
AND PSP.ORG_ID = PRL.ORG_ID ) ) ) )
AND PLT.LINE_TYPE_ID = POL.LINE_TYPE_ID
AND MUOM.UNIT_OF_MEASURE (+) = POL.UNIT_MEAS_LOOKUP_CODE
AND POUNT.UN_NUMBER_ID (+) = POL.UN_NUMBER_ID
AND POUNT.LANGUAGE (+) = USERENV('LANG')
AND PHCT.HAZARD_CLASS_ID (+) = POL.HAZARD_CLASS_ID
AND PHCT.LANGUAGE (+) = USERENV('LANG')
AND POH2.PO_HEADER_ID (+) = POL.FROM_HEADER_ID
AND POV.VENDOR_ID (+) = POH.VENDOR_ID
AND POVS.VENDOR_SITE_ID (+) = POH.VENDOR_SITE_ID
AND POVC.VENDOR_CONTACT_ID (+) = POH.VENDOR_CONTACT_ID
AND HRL.LOCATION_ID (+) = POH.BILL_TO_LOCATION_ID
AND HRL.LANGUAGE (+) = USERENV('LANG')
AND HRL2.LOCATION_ID (+) = POH.SHIP_TO_LOCATION_ID
AND HRL2.LANGUAGE (+) = USERENV('LANG')
AND PDT.DOCUMENT_TYPE_CODE IN ('PO'
, 'PA')
AND PDT.DOCUMENT_SUBTYPE = POH.TYPE_LOOKUP_CODE
AND PDTL.DOCUMENT_TYPE_CODE = PDT.DOCUMENT_TYPE_CODE
AND PDTL.DOCUMENT_SUBTYPE = PDT.DOCUMENT_SUBTYPE
AND PDTL.LANGUAGE = USERENV('LANG')
AND PDT.ORG_ID = POH.ORG_ID
AND PDTL.ORG_ID = PDT.ORG_ID
AND APT.TERM_ID (+) = POH.TERMS_ID
AND GLDC.CONVERSION_TYPE (+) = POH.RATE_TYPE
AND HOUTL.ORGANIZATION_ID(+) = POH.ORG_ID
AND HOUTL.LANGUAGE(+) = USERENV('LANG')
AND ( POH.VENDOR_CONTACT_ID IS NULL OR POH.VENDOR_SITE_ID=POVC.VENDOR_SITE_ID )