View: RCV_TRANSACTIONS_MRC_V

Product:	PO - Purchasing
Description:	- Retrofitted
Implementation/DBA Data:	APPS.RCV_TRANSACTIONS_MRC_V

View Text

SELECT PO.TRANSACTION_ID
, MC.CURRENCY_CONVERSION_TYPE
, MC.CURRENCY_CONVERSION_DATE
, MC.CURRENCY_CONVERSION_RATE
, PO.PO_UNIT_PRICE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, TRANSACTION_TYPE
, TRANSACTION_DATE
, QUANTITY
, UNIT_OF_MEASURE
, SHIPMENT_HEADER_ID
, SHIPMENT_LINE_ID
, USER_ENTERED_FLAG
, INTERFACE_SOURCE_CODE
, INTERFACE_SOURCE_LINE_ID
, INV_TRANSACTION_ID
, SOURCE_DOCUMENT_CODE
, DESTINATION_TYPE_CODE
, PRIMARY_QUANTITY
, PRIMARY_UNIT_OF_MEASURE
, UOM_CODE
, EMPLOYEE_ID
, PARENT_TRANSACTION_ID
, PO_HEADER_ID
, PO_RELEASE_ID
, PO_LINE_ID
, PO_LINE_LOCATION_ID
, PO_DISTRIBUTION_ID
, PO_REVISION_NUM
, REQUISITION_LINE_ID
, CURRENCY_CODE
, ROUTING_HEADER_ID
, ROUTING_STEP_ID
, DELIVER_TO_PERSON_ID
, DELIVER_TO_LOCATION_ID
, VENDOR_ID
, VENDOR_SITE_ID
, ORGANIZATION_ID
, SUBINVENTORY
, LOCATOR_ID
, WIP_ENTITY_ID
, WIP_LINE_ID
, WIP_REPETITIVE_SCHEDULE_ID
, WIP_OPERATION_SEQ_NUM
, WIP_RESOURCE_SEQ_NUM
, BOM_RESOURCE_ID
, LOCATION_ID
, SUBSTITUTE_UNORDERED_CODE
, RECEIPT_EXCEPTION_FLAG
, INSPECTION_STATUS_CODE
, ACCRUAL_STATUS_CODE
, INSPECTION_QUALITY_CODE
, VENDOR_LOT_NUM
, RMA_REFERENCE
, COMMENTS
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, REQ_DISTRIBUTION_ID
, DEPARTMENT_CODE
, REASON_ID
, DESTINATION_CONTEXT
, LOCATOR_ATTRIBUTE
, CHILD_INSPECTION_FLAG
, SOURCE_DOC_UNIT_OF_MEASURE
, SOURCE_DOC_QUANTITY
, INTERFACE_TRANSACTION_ID
, GROUP_ID
, MOVEMENT_ID
, INVOICE_STATUS_CODE
, INVOICE_ID
, QA_COLLECTION_ID
, MRC_CURRENCY_CONVERSION_TYPE
, MRC_CURRENCY_CONVERSION_DATE
, MRC_CURRENCY_CONVERSION_RATE
, AMOUNT_BILLED
, COUNTRY_OF_ORIGIN_CODE
, MATCH_OPTION
, MVT_STAT_STATUS
, QUANTITY_BILLED
, CUSTOMER_ID
, CUSTOMER_SITE_ID
, MATCH_FLAG
, OE_ORDER_HEADER_ID
, OE_ORDER_LINE_ID
, LPN_ID
, TRANSFER_LPN_ID
, MOBILE_TXN
, SECONDARY_QUANTITY
, SECONDARY_UNIT_OF_MEASURE
, QC_GRADE
, SECONDARY_UOM_CODE
, PA_ADDITION_FLAG
, PO.CONSIGNED_FLAG
, PO.SOURCE_TRANSACTION_NUM
, PO.FROM_SUBINVENTORY
, PO.FROM_LOCATOR_ID
, PO.AMOUNT
, PO.DROPSHIP_TYPE_CODE
, PO.LPN_GROUP_ID
, PO.JOB_ID
, PO.TIMECARD_ID
, PO.TIMECARD_OVN
, PO.PROJECT_ID
, PO.TASK_ID
FROM RCV_TRANSACTIONS PO
, RCV_MC_TRANSACTIONS MC
WHERE PO.TRANSACTION_ID = MC.TRANSACTION_ID
AND MC.SET_OF_BOOKS_ID = NVL (TO_NUMBER (SUBSTRB (USERENV ('CLIENT_INFO')
, 45
, 10))
, -99)

Columns