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

Source

View Text - Preformatted


SELECT 'N' LINE_CHKBOX, 'VENDOR' SOURCE_TYPE_CODE, 'VENDOR' RECEIPT_SOURCE_CODE, 'PO' ORDER_TYPE_CODE, POH.TYPE_LOOKUP_CODE ORDER_TYPE, POLL.PO_HEADER_ID PO_HEADER_ID, POH.SEGMENT1 PO_NUMBER, POLL.PO_LINE_ID PO_LINE_ID, POL.LINE_NUM PO_LINE_NUMBER, POLL.LINE_LOCATION_ID PO_LINE_LOCATION_ID, POLL.SHIPMENT_NUM PO_SHIPMENT_NUMBER, POLL.PO_RELEASE_ID PO_RELEASE_ID, POR.RELEASE_NUM PO_RELEASE_NUMBER, TO_NUMBER(NULL) REQ_HEADER_ID, NULL REQ_NUMBER, TO_NUMBER(NULL) REQ_LINE_ID, TO_NUMBER(NULL) REQ_LINE, TO_NUMBER(NULL) REQ_DISTRIBUTION_ID, TO_NUMBER(NULL) RCV_SHIPMENT_HEADER_ID, NULL RCV_SHIPMENT_NUMBER, TO_NUMBER(NULL) RCV_SHIPMENT_LINE_ID, TO_NUMBER(NULL) RCV_LINE_NUMBER, POH.PO_HEADER_ID FROM_ORGANIZATION_ID, POLL.SHIP_TO_ORGANIZATION_ID TO_ORGANIZATION_ID, POH.VENDOR_ID VENDOR_ID, POV.VENDOR_NAME SOURCE, POH.VENDOR_SITE_ID VENDOR_SITE_ID, NVL(POLT.OUTSIDE_OPERATION_FLAG,'N') OUTSIDE_OPERATION_FLAG, POL.ITEM_ID ITEM_ID, MUM.UNIT_OF_MEASURE PRIMARY_UOM, MUM.UOM_CLASS PRIMARY_UOM_CLASS, NVL(MSI.ALLOWED_UNITS_LOOKUP_CODE,2) ITEM_ALLOWED_UNITS_LOOKUP_CODE, NVL(MSI.LOCATION_CONTROL_CODE,1) ITEM_LOCATOR_CONTROL, DECODE(MSI.RESTRICT_LOCATORS_CODE,1,'Y','N') RESTRICT_LOCATORS_CODE, DECODE(MSI.RESTRICT_SUBINVENTORIES_CODE,1,'Y','N') RESTRICT_SUBINVENTORIES_CODE, NVL(MSI.SHELF_LIFE_CODE,1) SHELF_LIFE_CODE, NVL(MSI.SHELF_LIFE_DAYS,0) SHELF_LIFE_DAYS, MSI.SERIAL_NUMBER_CONTROL_CODE SERIAL_NUMBER_CONTROL_CODE, MSI.LOT_CONTROL_CODE LOT_CONTROL_CODE, DECODE(MSI.REVISION_QTY_CONTROL_CODE,1,'N',2,'Y','N') ITEM_REV_CONTROL_FLAG_TO, NULL ITEM_REV_CONTROL_FLAG_FROM, NULL ITEM_NUMBER, POL.ITEM_REVISION ITEM_REVISION, POL.ITEM_DESCRIPTION ITEM_DESCRIPTION, POL.CATEGORY_ID ITEM_CATEGORY_ID, POHC.HAZARD_CLASS HAZARD_CLASS, POUN.UN_NUMBER UN_NUMBER, POL.VENDOR_PRODUCT_NUM VENDOR_ITEM_NUMBER, POLL.SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID, HL.LOCATION_CODE SHIP_TO_LOCATION, NULL PACKING_SLIP, POLL.RECEIVING_ROUTING_ID ROUTING_ID, RCVRH.ROUTING_NAME ROUTING_NAME, POLL.NEED_BY_DATE NEED_BY_DATE, NVL(POLL.PROMISED_DATE, POLL.NEED_BY_DATE)EXPECTED_RECEIPT_DATE, POLL.QUANTITY ORDERED_QTY, POL.UNIT_MEAS_LOOKUP_CODE ORDERED_UOM, NULL USSGL_TRANSACTION_CODE, POLL.GOVERNMENT_CONTEXT GOVERNMENT_CONTEXT, POLL.INSPECTION_REQUIRED_FLAG INSPECTION_REQUIRED_FLAG, POLL.RECEIPT_REQUIRED_FLAG RECEIPT_REQUIRED_FLAG, POLL.ENFORCE_SHIP_TO_LOCATION_CODE ENFORCE_SHIP_TO_LOCATION_CODE, NVL(POLL.PRICE_OVERRIDE, POL.UNIT_PRICE)UNIT_PRICE, POH.CURRENCY_CODE CURRENCY_CODE, POH.RATE_TYPE CURRENCY_CONVERSION_TYPE, POH.RATE_DATE CURRENCY_CONVERSION_DATE, POH.RATE CURRENCY_CONVERSION_RATE, POH.NOTE_TO_RECEIVER NOTE_TO_RECEIVER, NULL DESTINATION_TYPE_CODE, TO_NUMBER(NULL) DELIVER_TO_PERSON_ID, TO_NUMBER(NULL) DELIVER_TO_LOCATION_ID, NULL DESTINATION_SUBINVENTORY, POLL.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, POLL.ATTRIBUTE1 ATTRIBUTE1, POLL.ATTRIBUTE2 ATTRIBUTE2, POLL.ATTRIBUTE3 ATTRIBUTE3, POLL.ATTRIBUTE4 ATTRIBUTE4, POLL.ATTRIBUTE5 ATTRIBUTE5, POLL.ATTRIBUTE6 ATTRIBUTE6, POLL.ATTRIBUTE7 ATTRIBUTE7, POLL.ATTRIBUTE8 ATTRIBUTE8, POLL.ATTRIBUTE9 ATTRIBUTE9, POLL.ATTRIBUTE10 ATTRIBUTE10, POLL.ATTRIBUTE11 ATTRIBUTE11, POLL.ATTRIBUTE12 ATTRIBUTE12, POLL.ATTRIBUTE13 ATTRIBUTE13, POLL.ATTRIBUTE14 ATTRIBUTE14, POLL.ATTRIBUTE15 ATTRIBUTE15, POLL.CLOSED_CODE CLOSED_CODE, null ASN_TYPE, null BILL_OF_LADING, to_date(null) SHIPPED_DATE, null FREIGHT_CARRIER_CODE, null WAYBILL_AIRBILL_NUM, null FREIGHT_BILL_NUM, null VENDOR_LOT_NUM, null CONTAINER_NUM, null TRUCK_NUM, null BAR_CODE_LABEL, DCT.USER_CONVERSION_TYPE RATE_TYPE_DISPLAY, POLL.MATCH_OPTION MATCH_OPTION, POLL.COUNTRY_OF_ORIGIN_CODE COUNTRY_OF_ORIGIN_CODE, TO_NUMBER(NULL) OE_ORDER_HEADER_ID, TO_NUMBER(NULL) OE_ORDER_NUM, TO_NUMBER(NULL) OE_ORDER_LINE_ID, TO_NUMBER(NULL) OE_ORDER_LINE_NUM, TO_NUMBER(NULL) CUSTOMER_ID, TO_NUMBER(NULL) CUSTOMER_SITE_ID, null CUSTOMER_ITEM_NUM, POLL.NOTE_TO_RECEIVER PLL_NOTE_TO_RECEIVER, POLL.SECONDARY_QUANTITY SECONDARY_ORDERED_QTY, POLL.SECONDARY_UNIT_OF_MEASURE SECONDARY_ORDERED_UOM, POLL.PREFERRED_GRADE QC_GRADE, TO_NUMBER(NULL) LPN_ID, DECODE(MSI.TRACKING_QUANTITY_IND, 'PS', MSI.SECONDARY_DEFAULT_IND,NULL) SECONDARY_DEFAULT_IND, POLL.ORG_ID ORG_ID, to_number(null) OE_ORDER_SHIP_NUM, TO_NUMBER( NULL) LCM_SHIPMENT_LINE_ID, TO_NUMBER( NULL) UNIT_LANDED_COST, POLL.lcm_flag LCM_SHIPMENT_FLAG FROM PO_HEADERS_ALL POH, PO_LINE_LOCATIONS POLL, PO_LINES_ALL POL, PO_RELEASES_ALL POR, PO_VENDORS POV, PO_HAZARD_CLASSES_TL POHC, PO_UN_NUMBERS_TL POUN, RCV_ROUTING_HEADERS RCVRH, HR_LOCATIONS_ALL_TL HL, MTL_SYSTEM_ITEMS MSI, MTL_UNITS_OF_MEASURE MUM, PO_LINE_TYPES_B POLT , GL_DAILY_CONVERSION_TYPES DCT WHERE NVL(POLL.APPROVED_FLAG,'N') = 'Y' AND NVL(POLL.CANCEL_FLAG, 'N') = 'N' AND NVL(POLL.CLOSED_CODE,'OPEN') != 'FINALLY CLOSED' AND POLL.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED') AND POH.PO_HEADER_ID = POLL.PO_HEADER_ID AND POL.PO_LINE_ID = POLL.PO_LINE_ID AND POL.HAZARD_CLASS_ID = POHC.HAZARD_CLASS_ID(+) AND POHC.LANGUAGE(+) = USERENV('LANG') AND POL.UN_NUMBER_ID = POUN.UN_NUMBER_ID (+) AND POUN.LANGUAGE(+) = USERENV('LANG') AND POLL.PO_RELEASE_ID = POR.PO_RELEASE_ID(+) AND POLL.SHIP_TO_LOCATION_ID = HL.LOCATION_ID(+) AND HL.LANGUAGE(+) = USERENV('LANG') AND POH.VENDOR_ID = POV.VENDOR_ID(+) AND POL.LINE_TYPE_ID = POLT.LINE_TYPE_ID(+) AND POLL.RECEIVING_ROUTING_ID = RCVRH.ROUTING_HEADER_ID(+) AND MUM.UOM_CODE (+) = MSI.PRIMARY_UOM_CODE AND NVL(MSI.ORGANIZATION_ID,POLL.SHIP_TO_ORGANIZATION_ID) = POLL.SHIP_TO_ORGANIZATION_ID AND MSI.INVENTORY_ITEM_ID (+) = POL.ITEM_ID AND DCT.CONVERSION_TYPE (+) = POH.RATE_TYPE AND NVL( POH.CONSIGNED_CONSUMPTION_FLAG,'N') = 'N' AND NVL( POR.CONSIGNED_CONSUMPTION_FLAG,'N') = 'N' AND NVL(POLL.MATCHING_BASIS,'QUANTITY') != 'AMOUNT' AND POLL.PAYMENT_TYPE IS NULL AND NVL(POLL.LCM_FLAG,'N') = 'Y'

View Text - HTML Formatted

SELECT 'N' LINE_CHKBOX
, 'VENDOR' SOURCE_TYPE_CODE
, 'VENDOR' RECEIPT_SOURCE_CODE
, 'PO' ORDER_TYPE_CODE
, POH.TYPE_LOOKUP_CODE ORDER_TYPE
, POLL.PO_HEADER_ID PO_HEADER_ID
, POH.SEGMENT1 PO_NUMBER
, POLL.PO_LINE_ID PO_LINE_ID
, POL.LINE_NUM PO_LINE_NUMBER
, POLL.LINE_LOCATION_ID PO_LINE_LOCATION_ID
, POLL.SHIPMENT_NUM PO_SHIPMENT_NUMBER
, POLL.PO_RELEASE_ID PO_RELEASE_ID
, POR.RELEASE_NUM PO_RELEASE_NUMBER
, TO_NUMBER(NULL) REQ_HEADER_ID
, NULL REQ_NUMBER
, TO_NUMBER(NULL) REQ_LINE_ID
, TO_NUMBER(NULL) REQ_LINE
, TO_NUMBER(NULL) REQ_DISTRIBUTION_ID
, TO_NUMBER(NULL) RCV_SHIPMENT_HEADER_ID
, NULL RCV_SHIPMENT_NUMBER
, TO_NUMBER(NULL) RCV_SHIPMENT_LINE_ID
, TO_NUMBER(NULL) RCV_LINE_NUMBER
, POH.PO_HEADER_ID FROM_ORGANIZATION_ID
, POLL.SHIP_TO_ORGANIZATION_ID TO_ORGANIZATION_ID
, POH.VENDOR_ID VENDOR_ID
, POV.VENDOR_NAME SOURCE
, POH.VENDOR_SITE_ID VENDOR_SITE_ID
, NVL(POLT.OUTSIDE_OPERATION_FLAG
, 'N') OUTSIDE_OPERATION_FLAG
, POL.ITEM_ID ITEM_ID
, MUM.UNIT_OF_MEASURE PRIMARY_UOM
, MUM.UOM_CLASS PRIMARY_UOM_CLASS
, NVL(MSI.ALLOWED_UNITS_LOOKUP_CODE
, 2) ITEM_ALLOWED_UNITS_LOOKUP_CODE
, NVL(MSI.LOCATION_CONTROL_CODE
, 1) ITEM_LOCATOR_CONTROL
, DECODE(MSI.RESTRICT_LOCATORS_CODE
, 1
, 'Y'
, 'N') RESTRICT_LOCATORS_CODE
, DECODE(MSI.RESTRICT_SUBINVENTORIES_CODE
, 1
, 'Y'
, 'N') RESTRICT_SUBINVENTORIES_CODE
, NVL(MSI.SHELF_LIFE_CODE
, 1) SHELF_LIFE_CODE
, NVL(MSI.SHELF_LIFE_DAYS
, 0) SHELF_LIFE_DAYS
, MSI.SERIAL_NUMBER_CONTROL_CODE SERIAL_NUMBER_CONTROL_CODE
, MSI.LOT_CONTROL_CODE LOT_CONTROL_CODE
, DECODE(MSI.REVISION_QTY_CONTROL_CODE
, 1
, 'N'
, 2
, 'Y'
, 'N') ITEM_REV_CONTROL_FLAG_TO
, NULL ITEM_REV_CONTROL_FLAG_FROM
, NULL ITEM_NUMBER
, POL.ITEM_REVISION ITEM_REVISION
, POL.ITEM_DESCRIPTION ITEM_DESCRIPTION
, POL.CATEGORY_ID ITEM_CATEGORY_ID
, POHC.HAZARD_CLASS HAZARD_CLASS
, POUN.UN_NUMBER UN_NUMBER
, POL.VENDOR_PRODUCT_NUM VENDOR_ITEM_NUMBER
, POLL.SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID
, HL.LOCATION_CODE SHIP_TO_LOCATION
, NULL PACKING_SLIP
, POLL.RECEIVING_ROUTING_ID ROUTING_ID
, RCVRH.ROUTING_NAME ROUTING_NAME
, POLL.NEED_BY_DATE NEED_BY_DATE
, NVL(POLL.PROMISED_DATE
, POLL.NEED_BY_DATE)EXPECTED_RECEIPT_DATE
, POLL.QUANTITY ORDERED_QTY
, POL.UNIT_MEAS_LOOKUP_CODE ORDERED_UOM
, NULL USSGL_TRANSACTION_CODE
, POLL.GOVERNMENT_CONTEXT GOVERNMENT_CONTEXT
, POLL.INSPECTION_REQUIRED_FLAG INSPECTION_REQUIRED_FLAG
, POLL.RECEIPT_REQUIRED_FLAG RECEIPT_REQUIRED_FLAG
, POLL.ENFORCE_SHIP_TO_LOCATION_CODE ENFORCE_SHIP_TO_LOCATION_CODE
, NVL(POLL.PRICE_OVERRIDE
, POL.UNIT_PRICE)UNIT_PRICE
, POH.CURRENCY_CODE CURRENCY_CODE
, POH.RATE_TYPE CURRENCY_CONVERSION_TYPE
, POH.RATE_DATE CURRENCY_CONVERSION_DATE
, POH.RATE CURRENCY_CONVERSION_RATE
, POH.NOTE_TO_RECEIVER NOTE_TO_RECEIVER
, NULL DESTINATION_TYPE_CODE
, TO_NUMBER(NULL) DELIVER_TO_PERSON_ID
, TO_NUMBER(NULL) DELIVER_TO_LOCATION_ID
, NULL DESTINATION_SUBINVENTORY
, POLL.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, POLL.ATTRIBUTE1 ATTRIBUTE1
, POLL.ATTRIBUTE2 ATTRIBUTE2
, POLL.ATTRIBUTE3 ATTRIBUTE3
, POLL.ATTRIBUTE4 ATTRIBUTE4
, POLL.ATTRIBUTE5 ATTRIBUTE5
, POLL.ATTRIBUTE6 ATTRIBUTE6
, POLL.ATTRIBUTE7 ATTRIBUTE7
, POLL.ATTRIBUTE8 ATTRIBUTE8
, POLL.ATTRIBUTE9 ATTRIBUTE9
, POLL.ATTRIBUTE10 ATTRIBUTE10
, POLL.ATTRIBUTE11 ATTRIBUTE11
, POLL.ATTRIBUTE12 ATTRIBUTE12
, POLL.ATTRIBUTE13 ATTRIBUTE13
, POLL.ATTRIBUTE14 ATTRIBUTE14
, POLL.ATTRIBUTE15 ATTRIBUTE15
, POLL.CLOSED_CODE CLOSED_CODE
, NULL ASN_TYPE
, NULL BILL_OF_LADING
, TO_DATE(NULL) SHIPPED_DATE
, NULL FREIGHT_CARRIER_CODE
, NULL WAYBILL_AIRBILL_NUM
, NULL FREIGHT_BILL_NUM
, NULL VENDOR_LOT_NUM
, NULL CONTAINER_NUM
, NULL TRUCK_NUM
, NULL BAR_CODE_LABEL
, DCT.USER_CONVERSION_TYPE RATE_TYPE_DISPLAY
, POLL.MATCH_OPTION MATCH_OPTION
, POLL.COUNTRY_OF_ORIGIN_CODE COUNTRY_OF_ORIGIN_CODE
, TO_NUMBER(NULL) OE_ORDER_HEADER_ID
, TO_NUMBER(NULL) OE_ORDER_NUM
, TO_NUMBER(NULL) OE_ORDER_LINE_ID
, TO_NUMBER(NULL) OE_ORDER_LINE_NUM
, TO_NUMBER(NULL) CUSTOMER_ID
, TO_NUMBER(NULL) CUSTOMER_SITE_ID
, NULL CUSTOMER_ITEM_NUM
, POLL.NOTE_TO_RECEIVER PLL_NOTE_TO_RECEIVER
, POLL.SECONDARY_QUANTITY SECONDARY_ORDERED_QTY
, POLL.SECONDARY_UNIT_OF_MEASURE SECONDARY_ORDERED_UOM
, POLL.PREFERRED_GRADE QC_GRADE
, TO_NUMBER(NULL) LPN_ID
, DECODE(MSI.TRACKING_QUANTITY_IND
, 'PS'
, MSI.SECONDARY_DEFAULT_IND
, NULL) SECONDARY_DEFAULT_IND
, POLL.ORG_ID ORG_ID
, TO_NUMBER(NULL) OE_ORDER_SHIP_NUM
, TO_NUMBER( NULL) LCM_SHIPMENT_LINE_ID
, TO_NUMBER( NULL) UNIT_LANDED_COST
, POLL.LCM_FLAG LCM_SHIPMENT_FLAG
FROM PO_HEADERS_ALL POH
, PO_LINE_LOCATIONS POLL
, PO_LINES_ALL POL
, PO_RELEASES_ALL POR
, PO_VENDORS POV
, PO_HAZARD_CLASSES_TL POHC
, PO_UN_NUMBERS_TL POUN
, RCV_ROUTING_HEADERS RCVRH
, HR_LOCATIONS_ALL_TL HL
, MTL_SYSTEM_ITEMS MSI
, MTL_UNITS_OF_MEASURE MUM
, PO_LINE_TYPES_B POLT
, GL_DAILY_CONVERSION_TYPES DCT
WHERE NVL(POLL.APPROVED_FLAG
, 'N') = 'Y'
AND NVL(POLL.CANCEL_FLAG
, 'N') = 'N'
AND NVL(POLL.CLOSED_CODE
, 'OPEN') != 'FINALLY CLOSED'
AND POLL.SHIPMENT_TYPE IN ('STANDARD'
, 'BLANKET'
, 'SCHEDULED')
AND POH.PO_HEADER_ID = POLL.PO_HEADER_ID
AND POL.PO_LINE_ID = POLL.PO_LINE_ID
AND POL.HAZARD_CLASS_ID = POHC.HAZARD_CLASS_ID(+)
AND POHC.LANGUAGE(+) = USERENV('LANG')
AND POL.UN_NUMBER_ID = POUN.UN_NUMBER_ID (+)
AND POUN.LANGUAGE(+) = USERENV('LANG')
AND POLL.PO_RELEASE_ID = POR.PO_RELEASE_ID(+)
AND POLL.SHIP_TO_LOCATION_ID = HL.LOCATION_ID(+)
AND HL.LANGUAGE(+) = USERENV('LANG')
AND POH.VENDOR_ID = POV.VENDOR_ID(+)
AND POL.LINE_TYPE_ID = POLT.LINE_TYPE_ID(+)
AND POLL.RECEIVING_ROUTING_ID = RCVRH.ROUTING_HEADER_ID(+)
AND MUM.UOM_CODE (+) = MSI.PRIMARY_UOM_CODE
AND NVL(MSI.ORGANIZATION_ID
, POLL.SHIP_TO_ORGANIZATION_ID) = POLL.SHIP_TO_ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID (+) = POL.ITEM_ID
AND DCT.CONVERSION_TYPE (+) = POH.RATE_TYPE
AND NVL( POH.CONSIGNED_CONSUMPTION_FLAG
, 'N') = 'N'
AND NVL( POR.CONSIGNED_CONSUMPTION_FLAG
, 'N') = 'N'
AND NVL(POLL.MATCHING_BASIS
, 'QUANTITY') != 'AMOUNT'
AND POLL.PAYMENT_TYPE IS NULL
AND NVL(POLL.LCM_FLAG
, 'N') = 'Y'