View: RCV_MUR_V

Product:	PO - Purchasing
Description:	10SC ONLY - Retrofitted
Implementation/DBA Data:	APPS.RCV_MUR_V

View Text

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
, 50)
, NULL) CUSTOMER_NAME
, RT.CUSTOMER_SITE_ID
, RT.SECONDARY_QUANTITY
, RT.SECONDARY_UNIT_OF_MEASURE
, RT.QC_GRADE
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 NOT EXISTS ( SELECT 'RETURNED'
FROM RCV_TRANSACTIONS RT_SUB WHERE RT_SUB.TRANSACTION_TYPE = 'RETURN TO VENDOR' AND RT_SUB.PARENT_TRANSACTION_ID = RT.TRANSACTION_ID AND RT.QUANTITY = (SELECT SUM(QUANTITY)
FROM RCV_TRANSACTIONS RT_SUB1 WHERE RT_SUB1.PARENT_TRANSACTION_ID = RT_SUB.PARENT_TRANSACTION_ID GROUP BY RT_SUB.PARENT_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 HRE.EMPLOYEE_NUMBER (+) IS NOT NULL
AND TRUNC(SYSDATE) BETWEEN HRE.EFFECTIVE_START_DATE (+)
AND HRE.EFFECTIVE_END_DATE (+)
AND DECODE(HR_SECURITY.VIEW_ALL
, 'Y'
, 'TRUE'
, HR_SECURITY.SHOW_RECORD('PER_ALL_PEOPLE_F'
, HRE.PERSON_ID (+)
, HRE.PERSON_TYPE_ID (+)
, HRE.EMPLOYEE_NUMBER (+)
, HRE.APPLICANT_NUMBER (+))) = 'TRUE'
AND DECODE(HR_GENERAL.GET_XBG_PROFILE
, 'Y'
, HRE.BUSINESS_GROUP_ID (+)
, HR_GENERAL.GET_BUSINESS_GROUP_ID) = HRE.BUSINESS_GROUP_ID (+)

Columns