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.

APPS.PA_CHECK_COMMITMENTS dependencies on STANDARD

Line 291: AND PLL.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')

287: BETWEEN REQ.EFFECTIVE_START_DATE
288: AND REQ.EFFECTIVE_END_DATE */ /* commented for bug 11800494 */
289: AND NVL(POH.CLOSED_CODE,'OPEN') NOT IN ('CLOSED','FINALLY CLOSED')
290: AND NVL(PLL.CLOSED_CODE,'OPEN') NOT IN ('CLOSED','FINALLY CLOSED')
291: AND PLL.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')
292: AND POH.TYPE_LOOKUP_CODE IN ('STANDARD','BLANKET','PLANNED')
293: AND POH.TYPE_LOOKUP_CODE = PDT.DOCUMENT_SUBTYPE
294: AND PDT.DOCUMENT_TYPE_CODE IN ('PO','PA')
295: AND PLL.PO_RELEASE_ID = POR.PO_RELEASE_ID(+)

Line 292: AND POH.TYPE_LOOKUP_CODE IN ('STANDARD','BLANKET','PLANNED')

288: AND REQ.EFFECTIVE_END_DATE */ /* commented for bug 11800494 */
289: AND NVL(POH.CLOSED_CODE,'OPEN') NOT IN ('CLOSED','FINALLY CLOSED')
290: AND NVL(PLL.CLOSED_CODE,'OPEN') NOT IN ('CLOSED','FINALLY CLOSED')
291: AND PLL.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')
292: AND POH.TYPE_LOOKUP_CODE IN ('STANDARD','BLANKET','PLANNED')
293: AND POH.TYPE_LOOKUP_CODE = PDT.DOCUMENT_SUBTYPE
294: AND PDT.DOCUMENT_TYPE_CODE IN ('PO','PA')
295: AND PLL.PO_RELEASE_ID = POR.PO_RELEASE_ID(+)
296: AND NVL(POH.CANCEL_FLAG,'N') = 'N'

Line 377: AND PLL.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')

373: BETWEEN REQ.EFFECTIVE_START_DATE /* modified for bug 6367516 */
374: AND REQ.EFFECTIVE_END_DATE
375: AND NVL(POH.CLOSED_CODE,'OPEN') NOT IN ('CLOSED','FINALLY CLOSED')
376: AND NVL(PLL.CLOSED_CODE,'OPEN') NOT IN ('CLOSED','FINALLY CLOSED')
377: AND PLL.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')
378: AND POH.TYPE_LOOKUP_CODE IN ('STANDARD','BLANKET','PLANNED')
379: AND POH.TYPE_LOOKUP_CODE = PDT.DOCUMENT_SUBTYPE
380: AND PDT.DOCUMENT_TYPE_CODE IN ('PO','PA')
381: AND PLL.PO_RELEASE_ID = POR.PO_RELEASE_ID(+)

Line 378: AND POH.TYPE_LOOKUP_CODE IN ('STANDARD','BLANKET','PLANNED')

374: AND REQ.EFFECTIVE_END_DATE
375: AND NVL(POH.CLOSED_CODE,'OPEN') NOT IN ('CLOSED','FINALLY CLOSED')
376: AND NVL(PLL.CLOSED_CODE,'OPEN') NOT IN ('CLOSED','FINALLY CLOSED')
377: AND PLL.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')
378: AND POH.TYPE_LOOKUP_CODE IN ('STANDARD','BLANKET','PLANNED')
379: AND POH.TYPE_LOOKUP_CODE = PDT.DOCUMENT_SUBTYPE
380: AND PDT.DOCUMENT_TYPE_CODE IN ('PO','PA')
381: AND PLL.PO_RELEASE_ID = POR.PO_RELEASE_ID(+)
382: AND NVL(POH.CANCEL_FLAG,'N') = 'N'