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

Source

View Text - Preformatted


SELECT POH.SEGMENT1, /* 1 */ DECODE(POLL.MATCHING_BASIS, 'AMOUNT', (GREATEST(POD.AMOUNT_ORDERED - NVL(POD.AMOUNT_DELIVERED, 0) - NVL(POD.AMOUNT_CANCELLED, 0) + NVL(POD.NONRECOVERABLE_TAX,0),0) * NVL(POD.RATE,NVL(POH.RATE,1))), (GREATEST(POD.QUANTITY_ORDERED - NVL(POD.QUANTITY_BILLED, 0) - /* 2 */ NVL(POD.QUANTITY_CANCELLED, 0),0) * (NVL(POLL.PRICE_OVERRIDE,0) + NVL(POD.NONRECOVERABLE_TAX,0)) * NVL(POD.RATE,NVL(POH.RATE,1)))), DECODE(POLL.MATCHING_BASIS, 'AMOUNT', (GREATEST(POD.AMOUNT_ORDERED - NVL(POD.AMOUNT_DELIVERED, 0) - NVL(POD.AMOUNT_CANCELLED, 0) + NVL(POD.NONRECOVERABLE_TAX,0),0)), (GREATEST(POD.QUANTITY_ORDERED - NVL(POD.QUANTITY_BILLED, 0) - /* 3 */ NVL(POD.QUANTITY_CANCELLED, 0),0) * (NVL(POLL.PRICE_OVERRIDE,0) + NVL(POD.NONRECOVERABLE_TAX,0)))), NVL(POLL.PROMISED_DATE, NVL(POLL.NEED_BY_DATE, NVL(POR.ACCEPTANCE_DUE_DATE, /* 4 */ DECODE(POR.PO_RELEASE_ID, NULL, POLL.CREATION_DATE, POR.RELEASE_DATE)))), NVL(NVL(POH.CURRENCY_CODE,FSP.INVOICE_CURRENCY_CODE), SOB.CURRENCY_CODE), /* 5 */ DECODE(POLL.PO_RELEASE_ID, NULL,NVL(POH.AUTHORIZATION_STATUS,'INCOMPLETE'), /* 6 */ NVL(POR.AUTHORIZATION_STATUS,'INCOMPLETE')), DECODE(POH.VENDOR_SITE_ID, NULL,NVL(VENDOR.PAYMENT_PRIORITY,99), /* 7 */ NVL(SITE.PAYMENT_PRIORITY,99)), NVL(VENDOR.VENDOR_TYPE_LOOKUP_CODE,'-1'), /* 8 */ DECODE(POH.VENDOR_SITE_ID,NULL,NVL(VENDOR.PAY_GROUP_LOOKUP_CODE,'-1'), /* 9 */ NVL(SITE.PAY_GROUP_LOOKUP_CODE,'-1')), POD.ORG_ID /* 10 */ ,POD.PROJECT_ID, /* 11 */ POL.LINE_NUM, /* 12 */ TO_CHAR(POD.PO_DISTRIBUTION_ID), /* 13 */ POLL.VALUE_BASIS, /* 14 */ POL.PURCHASE_BASIS, /* 15 */ POLL.MATCHING_BASIS /* 16 */ FROM PO_HEADERS_ALL POH, PO_VENDOR_SITES_ALL SITE, PO_VENDORS VENDOR, PO_RELEASES_ALL POR, PO_LINES_ALL POL, PO_LINE_LOCATIONS_ALL POLL, PO_DISTRIBUTIONS_ALL POD, PO_DOCUMENT_TYPES_ALL PDT, FINANCIALS_SYSTEM_PARAMS_ALL FSP, GL_SETS_OF_BOOKS SOB WHERE (POH.ORG_ID = PDT.ORG_ID OR POH.ORG_ID IS NULL) AND (POL.ORG_ID = POH.ORG_ID OR POL.ORG_ID IS NULL) AND (POLL.ORG_ID = POL.ORG_ID OR POLL.ORG_ID IS NULL) AND (POD.ORG_ID = FSP.ORG_ID OR POD.ORG_ID IS NULL) AND (SITE.ORG_ID = POH.ORG_ID OR SITE.ORG_ID IS NULL) AND (POR.ORG_ID = POLL.ORG_ID OR POR.ORG_ID IS NULL) AND POH.VENDOR_SITE_ID = SITE.VENDOR_SITE_ID(+) AND POH.VENDOR_ID = VENDOR.VENDOR_ID (+) AND SOB.SET_OF_BOOKS_ID = POD.SET_OF_BOOKS_ID AND POD.SET_OF_BOOKS_ID = FSP.SET_OF_BOOKS_ID AND POD.LINE_LOCATION_ID = POLL.LINE_LOCATION_ID AND POLL.PO_RELEASE_ID = POR.PO_RELEASE_ID (+) AND POLL.SHIPMENT_TYPE IN ('STANDARD', 'BLANKET','PLANNED','SCHEDULED') AND POLL.PO_LINE_ID = POL.PO_LINE_ID AND POLL.PO_HEADER_ID = POL.PO_HEADER_ID AND POH.PO_HEADER_ID = POL.PO_HEADER_ID AND NVL(POH.CLOSED_CODE,'OPEN') NOT IN ('FROZEN','CANCELLED', 'FINALLY CLOSED') AND NVL(POH.CANCEL_FLAG,'N') = 'N' AND NVL(POH.FROZEN_FLAG,'N') = 'N' AND POH.TYPE_LOOKUP_CODE = PDT.DOCUMENT_SUBTYPE AND PDT.DOCUMENT_TYPE_CODE IN ('PO', 'PA') AND POLL.TERMS_ID IS NULL AND POH.TERMS_ID IS NULL AND SITE.TERMS_ID IS NULL AND VENDOR.TERMS_ID IS NULL AND NVL(POL.PURCHASE_BASIS, 'GOODS') NOT IN ('TEMP LABOR')

View Text - HTML Formatted

SELECT POH.SEGMENT1
, /* 1 */ DECODE(POLL.MATCHING_BASIS
, 'AMOUNT'
, (GREATEST(POD.AMOUNT_ORDERED - NVL(POD.AMOUNT_DELIVERED
, 0) - NVL(POD.AMOUNT_CANCELLED
, 0) + NVL(POD.NONRECOVERABLE_TAX
, 0)
, 0) * NVL(POD.RATE
, NVL(POH.RATE
, 1)))
, (GREATEST(POD.QUANTITY_ORDERED - NVL(POD.QUANTITY_BILLED
, 0) - /* 2 */ NVL(POD.QUANTITY_CANCELLED
, 0)
, 0) * (NVL(POLL.PRICE_OVERRIDE
, 0) + NVL(POD.NONRECOVERABLE_TAX
, 0)) * NVL(POD.RATE
, NVL(POH.RATE
, 1))))
, DECODE(POLL.MATCHING_BASIS
, 'AMOUNT'
, (GREATEST(POD.AMOUNT_ORDERED - NVL(POD.AMOUNT_DELIVERED
, 0) - NVL(POD.AMOUNT_CANCELLED
, 0) + NVL(POD.NONRECOVERABLE_TAX
, 0)
, 0))
, (GREATEST(POD.QUANTITY_ORDERED - NVL(POD.QUANTITY_BILLED
, 0) - /* 3 */ NVL(POD.QUANTITY_CANCELLED
, 0)
, 0) * (NVL(POLL.PRICE_OVERRIDE
, 0) + NVL(POD.NONRECOVERABLE_TAX
, 0))))
, NVL(POLL.PROMISED_DATE
, NVL(POLL.NEED_BY_DATE
, NVL(POR.ACCEPTANCE_DUE_DATE
, /* 4 */ DECODE(POR.PO_RELEASE_ID
, NULL
, POLL.CREATION_DATE
, POR.RELEASE_DATE))))
, NVL(NVL(POH.CURRENCY_CODE
, FSP.INVOICE_CURRENCY_CODE)
, SOB.CURRENCY_CODE)
, /* 5 */ DECODE(POLL.PO_RELEASE_ID
, NULL
, NVL(POH.AUTHORIZATION_STATUS
, 'INCOMPLETE')
, /* 6 */ NVL(POR.AUTHORIZATION_STATUS
, 'INCOMPLETE'))
, DECODE(POH.VENDOR_SITE_ID
, NULL
, NVL(VENDOR.PAYMENT_PRIORITY
, 99)
, /* 7 */ NVL(SITE.PAYMENT_PRIORITY
, 99))
, NVL(VENDOR.VENDOR_TYPE_LOOKUP_CODE
, '-1')
, /* 8 */ DECODE(POH.VENDOR_SITE_ID
, NULL
, NVL(VENDOR.PAY_GROUP_LOOKUP_CODE
, '-1')
, /* 9 */ NVL(SITE.PAY_GROUP_LOOKUP_CODE
, '-1'))
, POD.ORG_ID /* 10 */
, POD.PROJECT_ID
, /* 11 */ POL.LINE_NUM
, /* 12 */ TO_CHAR(POD.PO_DISTRIBUTION_ID)
, /* 13 */ POLL.VALUE_BASIS
, /* 14 */ POL.PURCHASE_BASIS
, /* 15 */ POLL.MATCHING_BASIS /* 16 */
FROM PO_HEADERS_ALL POH
, PO_VENDOR_SITES_ALL SITE
, PO_VENDORS VENDOR
, PO_RELEASES_ALL POR
, PO_LINES_ALL POL
, PO_LINE_LOCATIONS_ALL POLL
, PO_DISTRIBUTIONS_ALL POD
, PO_DOCUMENT_TYPES_ALL PDT
, FINANCIALS_SYSTEM_PARAMS_ALL FSP
, GL_SETS_OF_BOOKS SOB
WHERE (POH.ORG_ID = PDT.ORG_ID OR POH.ORG_ID IS NULL)
AND (POL.ORG_ID = POH.ORG_ID OR POL.ORG_ID IS NULL)
AND (POLL.ORG_ID = POL.ORG_ID OR POLL.ORG_ID IS NULL)
AND (POD.ORG_ID = FSP.ORG_ID OR POD.ORG_ID IS NULL)
AND (SITE.ORG_ID = POH.ORG_ID OR SITE.ORG_ID IS NULL)
AND (POR.ORG_ID = POLL.ORG_ID OR POR.ORG_ID IS NULL)
AND POH.VENDOR_SITE_ID = SITE.VENDOR_SITE_ID(+)
AND POH.VENDOR_ID = VENDOR.VENDOR_ID (+)
AND SOB.SET_OF_BOOKS_ID = POD.SET_OF_BOOKS_ID
AND POD.SET_OF_BOOKS_ID = FSP.SET_OF_BOOKS_ID
AND POD.LINE_LOCATION_ID = POLL.LINE_LOCATION_ID
AND POLL.PO_RELEASE_ID = POR.PO_RELEASE_ID (+)
AND POLL.SHIPMENT_TYPE IN ('STANDARD'
, 'BLANKET'
, 'PLANNED'
, 'SCHEDULED')
AND POLL.PO_LINE_ID = POL.PO_LINE_ID
AND POLL.PO_HEADER_ID = POL.PO_HEADER_ID
AND POH.PO_HEADER_ID = POL.PO_HEADER_ID
AND NVL(POH.CLOSED_CODE
, 'OPEN') NOT IN ('FROZEN'
, 'CANCELLED'
, 'FINALLY CLOSED')
AND NVL(POH.CANCEL_FLAG
, 'N') = 'N'
AND NVL(POH.FROZEN_FLAG
, 'N') = 'N'
AND POH.TYPE_LOOKUP_CODE = PDT.DOCUMENT_SUBTYPE
AND PDT.DOCUMENT_TYPE_CODE IN ('PO'
, 'PA')
AND POLL.TERMS_ID IS NULL
AND POH.TERMS_ID IS NULL
AND SITE.TERMS_ID IS NULL
AND VENDOR.TERMS_ID IS NULL
AND NVL(POL.PURCHASE_BASIS
, 'GOODS') NOT IN ('TEMP LABOR')