VIEW: APPS.RCV_TRANSACTIONS_MRC_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)