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

Source

View Text - Preformatted


SELECT RT.ROWID ROW_ID, RT.ORGANIZATION_ID, RT.TRANSACTION_ID, RT.PARENT_TRANSACTION_ID, RT.SHIPMENT_HEADER_ID, RT.SHIPMENT_LINE_ID, RT.TRANSACTION_TYPE, RT.TRANSACTION_DATE, RT.QUANTITY QTY_RECEIVED, RT.UNIT_OF_MEASURE RECEIVE_UOM, RT.UOM_CODE RECEIVE_UOM_CODE, RT.PRIMARY_UNIT_OF_MEASURE PRIMARY_UOM, RT.PRIMARY_QUANTITY PRIMARY_QTY, RT.LOCATION_ID RCV_LOCATION_ID, HRL.LOCATION_CODE RCV_LOCATION, HRL.DESCRIPTION RCV_LOCATION_DESC, RT.EMPLOYEE_ID RECEIVER_ID, HRE.FULL_NAME RECEIVER, RT.VENDOR_ID, DECODE(RT.SOURCE_DOCUMENT_CODE, 'RMA', NULL, POV.VENDOR_NAME) VENDOR_NAME, RT.VENDOR_SITE_ID, RT.INSPECTION_STATUS_CODE, RT.INSPECTION_QUALITY_CODE, RT.REASON_ID, RT.COMMENTS, RT.DESTINATION_TYPE_CODE, RT.DESTINATION_CONTEXT, RT.SUBINVENTORY, RT.LOCATOR_ID, RT.VENDOR_LOT_NUM, RT.ATTRIBUTE_CATEGORY, RT.ROUTING_HEADER_ID, RT.ROUTING_STEP_ID, RT.RECEIPT_EXCEPTION_FLAG, RT.CURRENCY_CODE, RT.CURRENCY_CONVERSION_RATE, RT.CURRENCY_CONVERSION_DATE, RT.CURRENCY_CONVERSION_TYPE, RT.SOURCE_DOCUMENT_CODE, RT.ATTRIBUTE1, RT.ATTRIBUTE2, RT.ATTRIBUTE3, RT.ATTRIBUTE4, RT.ATTRIBUTE5, RT.ATTRIBUTE6, RT.ATTRIBUTE7, RT.ATTRIBUTE8, RT.ATTRIBUTE9, RT.ATTRIBUTE10, RT.ATTRIBUTE11, RT.ATTRIBUTE12, RT.ATTRIBUTE13, RT.ATTRIBUTE14, RT.ATTRIBUTE15, RSH.RECEIPT_SOURCE_CODE, RSH.RECEIPT_NUM, RSH.USSGL_TRANSACTION_CODE, RSH.GOVERNMENT_CONTEXT, RSL.ITEM_ID, RSL.CATEGORY_ID ITEM_CATEGORY_ID, RSL.ITEM_REVISION, RSL.ITEM_DESCRIPTION ITEM_DESC, RSL.VENDOR_ITEM_NUM, RSL.CREATION_DATE, RSL.PACKING_SLIP, RT.COUNTRY_OF_ORIGIN_CODE, RT.CUSTOMER_ID, DECODE(RT.SOURCE_DOCUMENT_CODE, 'RMA',SUBSTR(HZP.PARTY_NAME,1,255) , NULL) CUSTOMER_NAME, RT.CUSTOMER_SITE_ID, RT.SECONDARY_QUANTITY, RT.SECONDARY_UNIT_OF_MEASURE, RT.QC_GRADE, RT.LCM_SHIPMENT_LINE_ID, RT.UNIT_LANDED_COST FROM RCV_TRANSACTIONS RT, RCV_SHIPMENT_HEADERS RSH, RCV_SHIPMENT_LINES RSL, PO_VENDORS POV, HR_LOCATIONS_ALL_TL HRL, PER_ALL_PEOPLE_F HRE, HZ_CUST_ACCOUNTS HZCA, HZ_PARTIES HZP WHERE RT.TRANSACTION_TYPE = 'UNORDERED' AND NOT EXISTS ( SELECT 'matched' FROM RCV_TRANSACTIONS RT_SUB WHERE RT_SUB.TRANSACTION_TYPE = 'MATCH' AND RT_SUB.PARENT_TRANSACTION_ID = RT.TRANSACTION_ID ) AND NOT EXISTS ( SELECT 'matched' FROM RCV_TRANSACTIONS_INTERFACE RTI WHERE RTI.TRANSACTION_TYPE = 'MATCH' AND RTI.PARENT_TRANSACTION_ID = RT.TRANSACTION_ID ) AND RSH.SHIPMENT_HEADER_ID = RT.SHIPMENT_HEADER_ID AND RSL.SHIPMENT_LINE_ID = RT.SHIPMENT_LINE_ID AND POV.VENDOR_ID (+)= RT.VENDOR_ID AND HZCA.CUST_ACCOUNT_ID (+) = RT.CUSTOMER_ID AND HZCA.PARTY_ID = HZP.PARTY_ID(+) AND HRL.LOCATION_ID (+)= RT.LOCATION_ID AND HRL.LANGUAGE (+) = USERENV('LANG') AND HRE.PERSON_ID (+) = RT.EMPLOYEE_ID AND TRUNC(SYSDATE) BETWEEN HRE.EFFECTIVE_START_DATE (+) AND HRE.EFFECTIVE_END_DATE (+) AND DECODE(HR_SECURITY.VIEW_ALL, 'Y', 'TRUE', HR_SECURITY.SHOW_PERSON (HRE.PERSON_ID (+), HRE.CURRENT_APPLICANT_FLAG (+), HRE.CURRENT_EMPLOYEE_FLAG (+), HRE.CURRENT_NPW_FLAG (+), HRE.EMPLOYEE_NUMBER (+), HRE.APPLICANT_NUMBER (+), HRE.NPW_NUMBER(+))) = 'TRUE' AND DECODE(HR_GENERAL.GET_XBG_PROFILE, 'Y', HRE.BUSINESS_GROUP_ID (+), HR_GENERAL.GET_BUSINESS_GROUP_ID) = HRE.BUSINESS_GROUP_ID (+) AND EXISTS ( SELECT 'RCV SUPPLY AVAILABLE' FROM RCV_SUPPLY RS WHERE RS.SUPPLY_TYPE_CODE = 'RECEIVING' AND RS.SUPPLY_SOURCE_ID = RT.TRANSACTION_ID )

View Text - HTML Formatted

SELECT RT.ROWID ROW_ID
, RT.ORGANIZATION_ID
, RT.TRANSACTION_ID
, RT.PARENT_TRANSACTION_ID
, RT.SHIPMENT_HEADER_ID
, RT.SHIPMENT_LINE_ID
, RT.TRANSACTION_TYPE
, RT.TRANSACTION_DATE
, RT.QUANTITY QTY_RECEIVED
, RT.UNIT_OF_MEASURE RECEIVE_UOM
, RT.UOM_CODE RECEIVE_UOM_CODE
, RT.PRIMARY_UNIT_OF_MEASURE PRIMARY_UOM
, RT.PRIMARY_QUANTITY PRIMARY_QTY
, RT.LOCATION_ID RCV_LOCATION_ID
, HRL.LOCATION_CODE RCV_LOCATION
, HRL.DESCRIPTION RCV_LOCATION_DESC
, RT.EMPLOYEE_ID RECEIVER_ID
, HRE.FULL_NAME RECEIVER
, RT.VENDOR_ID
, DECODE(RT.SOURCE_DOCUMENT_CODE
, 'RMA'
, NULL
, POV.VENDOR_NAME) VENDOR_NAME
, RT.VENDOR_SITE_ID
, RT.INSPECTION_STATUS_CODE
, RT.INSPECTION_QUALITY_CODE
, RT.REASON_ID
, RT.COMMENTS
, RT.DESTINATION_TYPE_CODE
, RT.DESTINATION_CONTEXT
, RT.SUBINVENTORY
, RT.LOCATOR_ID
, RT.VENDOR_LOT_NUM
, RT.ATTRIBUTE_CATEGORY
, RT.ROUTING_HEADER_ID
, RT.ROUTING_STEP_ID
, RT.RECEIPT_EXCEPTION_FLAG
, RT.CURRENCY_CODE
, RT.CURRENCY_CONVERSION_RATE
, RT.CURRENCY_CONVERSION_DATE
, RT.CURRENCY_CONVERSION_TYPE
, RT.SOURCE_DOCUMENT_CODE
, RT.ATTRIBUTE1
, RT.ATTRIBUTE2
, RT.ATTRIBUTE3
, RT.ATTRIBUTE4
, RT.ATTRIBUTE5
, RT.ATTRIBUTE6
, RT.ATTRIBUTE7
, RT.ATTRIBUTE8
, RT.ATTRIBUTE9
, RT.ATTRIBUTE10
, RT.ATTRIBUTE11
, RT.ATTRIBUTE12
, RT.ATTRIBUTE13
, RT.ATTRIBUTE14
, RT.ATTRIBUTE15
, RSH.RECEIPT_SOURCE_CODE
, RSH.RECEIPT_NUM
, RSH.USSGL_TRANSACTION_CODE
, RSH.GOVERNMENT_CONTEXT
, RSL.ITEM_ID
, RSL.CATEGORY_ID ITEM_CATEGORY_ID
, RSL.ITEM_REVISION
, RSL.ITEM_DESCRIPTION ITEM_DESC
, RSL.VENDOR_ITEM_NUM
, RSL.CREATION_DATE
, RSL.PACKING_SLIP
, RT.COUNTRY_OF_ORIGIN_CODE
, RT.CUSTOMER_ID
, DECODE(RT.SOURCE_DOCUMENT_CODE
, 'RMA'
, SUBSTR(HZP.PARTY_NAME
, 1
, 255)
, NULL) CUSTOMER_NAME
, RT.CUSTOMER_SITE_ID
, RT.SECONDARY_QUANTITY
, RT.SECONDARY_UNIT_OF_MEASURE
, RT.QC_GRADE
, RT.LCM_SHIPMENT_LINE_ID
, RT.UNIT_LANDED_COST
FROM RCV_TRANSACTIONS RT
, RCV_SHIPMENT_HEADERS RSH
, RCV_SHIPMENT_LINES RSL
, PO_VENDORS POV
, HR_LOCATIONS_ALL_TL HRL
, PER_ALL_PEOPLE_F HRE
, HZ_CUST_ACCOUNTS HZCA
, HZ_PARTIES HZP
WHERE RT.TRANSACTION_TYPE = 'UNORDERED'
AND NOT EXISTS ( SELECT 'MATCHED'
FROM RCV_TRANSACTIONS RT_SUB
WHERE RT_SUB.TRANSACTION_TYPE = 'MATCH'
AND RT_SUB.PARENT_TRANSACTION_ID = RT.TRANSACTION_ID )
AND NOT EXISTS ( SELECT 'MATCHED'
FROM RCV_TRANSACTIONS_INTERFACE RTI
WHERE RTI.TRANSACTION_TYPE = 'MATCH'
AND RTI.PARENT_TRANSACTION_ID = RT.TRANSACTION_ID )
AND RSH.SHIPMENT_HEADER_ID = RT.SHIPMENT_HEADER_ID
AND RSL.SHIPMENT_LINE_ID = RT.SHIPMENT_LINE_ID
AND POV.VENDOR_ID (+)= RT.VENDOR_ID
AND HZCA.CUST_ACCOUNT_ID (+) = RT.CUSTOMER_ID
AND HZCA.PARTY_ID = HZP.PARTY_ID(+)
AND HRL.LOCATION_ID (+)= RT.LOCATION_ID
AND HRL.LANGUAGE (+) = USERENV('LANG')
AND HRE.PERSON_ID (+) = RT.EMPLOYEE_ID
AND TRUNC(SYSDATE) BETWEEN HRE.EFFECTIVE_START_DATE (+)
AND HRE.EFFECTIVE_END_DATE (+)
AND DECODE(HR_SECURITY.VIEW_ALL
, 'Y'
, 'TRUE'
, HR_SECURITY.SHOW_PERSON (HRE.PERSON_ID (+)
, HRE.CURRENT_APPLICANT_FLAG (+)
, HRE.CURRENT_EMPLOYEE_FLAG (+)
, HRE.CURRENT_NPW_FLAG (+)
, HRE.EMPLOYEE_NUMBER (+)
, HRE.APPLICANT_NUMBER (+)
, HRE.NPW_NUMBER(+))) = 'TRUE'
AND DECODE(HR_GENERAL.GET_XBG_PROFILE
, 'Y'
, HRE.BUSINESS_GROUP_ID (+)
, HR_GENERAL.GET_BUSINESS_GROUP_ID) = HRE.BUSINESS_GROUP_ID (+)
AND EXISTS ( SELECT 'RCV SUPPLY AVAILABLE'
FROM RCV_SUPPLY RS
WHERE RS.SUPPLY_TYPE_CODE = 'RECEIVING'
AND RS.SUPPLY_SOURCE_ID = RT.TRANSACTION_ID )