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.

DBA Data [Home] [Help] [Dependency Information]

VIEW: PO.RCV_TRANSACTIONS_INTERFACE#

Object Details

Object Name:	RCV_TRANSACTIONS_INTERFACE#
Object Type:	VIEW
Owner:	PO
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
INTERFACE_TRANSACTION_ID	NUMBER		Yes
GROUP_ID	NUMBER
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER		Yes
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER		Yes
LAST_UPDATE_LOGIN	NUMBER
REQUEST_ID	NUMBER
PROGRAM_APPLICATION_ID	NUMBER
PROGRAM_ID	NUMBER
PROGRAM_UPDATE_DATE	DATE
TRANSACTION_TYPE	VARCHAR2	(25)	Yes
TRANSACTION_DATE	DATE		Yes
PROCESSING_STATUS_CODE	VARCHAR2	(25)	Yes
PROCESSING_MODE_CODE	VARCHAR2	(25)	Yes
PROCESSING_REQUEST_ID	NUMBER
TRANSACTION_STATUS_CODE	VARCHAR2	(25)	Yes
CATEGORY_ID	NUMBER
QUANTITY	NUMBER
UNIT_OF_MEASURE	VARCHAR2	(25)
INTERFACE_SOURCE_CODE	VARCHAR2	(30)
INTERFACE_SOURCE_LINE_ID	NUMBER
INV_TRANSACTION_ID	NUMBER
ITEM_ID	NUMBER
ITEM_DESCRIPTION	VARCHAR2	(240)
ITEM_REVISION	VARCHAR2	(3)
UOM_CODE	VARCHAR2	(3)
EMPLOYEE_ID	NUMBER	(9)
AUTO_TRANSACT_CODE	VARCHAR2	(25)
SHIPMENT_HEADER_ID	NUMBER
SHIPMENT_LINE_ID	NUMBER
SHIP_TO_LOCATION_ID	NUMBER
PRIMARY_QUANTITY	NUMBER
PRIMARY_UNIT_OF_MEASURE	VARCHAR2	(25)
RECEIPT_SOURCE_CODE	VARCHAR2	(25)
VENDOR_ID	NUMBER
VENDOR_SITE_ID	NUMBER
FROM_ORGANIZATION_ID	NUMBER
FROM_SUBINVENTORY	VARCHAR2	(10)
TO_ORGANIZATION_ID	NUMBER
INTRANSIT_OWNING_ORG_ID	NUMBER
ROUTING_HEADER_ID	NUMBER
ROUTING_STEP_ID	NUMBER
SOURCE_DOCUMENT_CODE	VARCHAR2	(25)
PARENT_TRANSACTION_ID	NUMBER
PO_HEADER_ID	NUMBER
PO_REVISION_NUM	NUMBER
PO_RELEASE_ID	NUMBER
PO_LINE_ID	NUMBER
PO_LINE_LOCATION_ID	NUMBER
PO_UNIT_PRICE	NUMBER
CURRENCY_CODE	VARCHAR2	(15)
CURRENCY_CONVERSION_TYPE	VARCHAR2	(30)
CURRENCY_CONVERSION_RATE	NUMBER
CURRENCY_CONVERSION_DATE	DATE
PO_DISTRIBUTION_ID	NUMBER
REQUISITION_LINE_ID	NUMBER
REQ_DISTRIBUTION_ID	NUMBER
CHARGE_ACCOUNT_ID	NUMBER
SUBSTITUTE_UNORDERED_CODE	VARCHAR2	(25)
RECEIPT_EXCEPTION_FLAG	VARCHAR2	(1)
ACCRUAL_STATUS_CODE	VARCHAR2	(25)
INSPECTION_STATUS_CODE	VARCHAR2	(25)
INSPECTION_QUALITY_CODE	VARCHAR2	(25)
DESTINATION_TYPE_CODE	VARCHAR2	(25)
DELIVER_TO_PERSON_ID	NUMBER
LOCATION_ID	NUMBER
DELIVER_TO_LOCATION_ID	NUMBER
SUBINVENTORY	VARCHAR2	(10)
LOCATOR_ID	NUMBER
WIP_ENTITY_ID	NUMBER
WIP_LINE_ID	NUMBER
DEPARTMENT_CODE	VARCHAR2	(10)
WIP_REPETITIVE_SCHEDULE_ID	NUMBER
WIP_OPERATION_SEQ_NUM	NUMBER
WIP_RESOURCE_SEQ_NUM	NUMBER
BOM_RESOURCE_ID	NUMBER
SHIPMENT_NUM	VARCHAR2	(30)
FREIGHT_CARRIER_CODE	VARCHAR2	(25)
BILL_OF_LADING	VARCHAR2	(25)
PACKING_SLIP	VARCHAR2	(25)
SHIPPED_DATE	DATE
EXPECTED_RECEIPT_DATE	DATE
ACTUAL_COST	NUMBER
TRANSFER_COST	NUMBER
TRANSPORTATION_COST	NUMBER
TRANSPORTATION_ACCOUNT_ID	NUMBER
NUM_OF_CONTAINERS	NUMBER
WAYBILL_AIRBILL_NUM	VARCHAR2	(30)
VENDOR_ITEM_NUM	VARCHAR2	(25)
VENDOR_LOT_NUM	VARCHAR2	(30)
RMA_REFERENCE	VARCHAR2	(30)
COMMENTS	VARCHAR2	(240)
ATTRIBUTE_CATEGORY	VARCHAR2	(30)
ATTRIBUTE1	VARCHAR2	(150)
ATTRIBUTE2	VARCHAR2	(150)
ATTRIBUTE3	VARCHAR2	(150)
ATTRIBUTE4	VARCHAR2	(150)
ATTRIBUTE5	VARCHAR2	(150)
ATTRIBUTE6	VARCHAR2	(150)
ATTRIBUTE7	VARCHAR2	(150)
ATTRIBUTE8	VARCHAR2	(150)
ATTRIBUTE9	VARCHAR2	(150)
ATTRIBUTE10	VARCHAR2	(150)
ATTRIBUTE11	VARCHAR2	(150)
ATTRIBUTE12	VARCHAR2	(150)
ATTRIBUTE13	VARCHAR2	(150)
ATTRIBUTE14	VARCHAR2	(150)
ATTRIBUTE15	VARCHAR2	(150)
SHIP_HEAD_ATTRIBUTE_CATEGORY	VARCHAR2	(30)
SHIP_HEAD_ATTRIBUTE1	VARCHAR2	(150)
SHIP_HEAD_ATTRIBUTE2	VARCHAR2	(150)
SHIP_HEAD_ATTRIBUTE3	VARCHAR2	(150)
SHIP_HEAD_ATTRIBUTE4	VARCHAR2	(150)
SHIP_HEAD_ATTRIBUTE5	VARCHAR2	(150)
SHIP_HEAD_ATTRIBUTE6	VARCHAR2	(150)
SHIP_HEAD_ATTRIBUTE7	VARCHAR2	(150)
SHIP_HEAD_ATTRIBUTE8	VARCHAR2	(150)
SHIP_HEAD_ATTRIBUTE9	VARCHAR2	(150)
SHIP_HEAD_ATTRIBUTE10	VARCHAR2	(150)
SHIP_HEAD_ATTRIBUTE11	VARCHAR2	(150)
SHIP_HEAD_ATTRIBUTE12	VARCHAR2	(150)
SHIP_HEAD_ATTRIBUTE13	VARCHAR2	(150)
SHIP_HEAD_ATTRIBUTE14	VARCHAR2	(150)
SHIP_HEAD_ATTRIBUTE15	VARCHAR2	(150)
SHIP_LINE_ATTRIBUTE_CATEGORY	VARCHAR2	(30)
SHIP_LINE_ATTRIBUTE1	VARCHAR2	(150)
SHIP_LINE_ATTRIBUTE2	VARCHAR2	(150)
SHIP_LINE_ATTRIBUTE3	VARCHAR2	(150)
SHIP_LINE_ATTRIBUTE4	VARCHAR2	(150)
SHIP_LINE_ATTRIBUTE5	VARCHAR2	(150)
SHIP_LINE_ATTRIBUTE6	VARCHAR2	(150)
SHIP_LINE_ATTRIBUTE7	VARCHAR2	(150)
SHIP_LINE_ATTRIBUTE8	VARCHAR2	(150)
SHIP_LINE_ATTRIBUTE9	VARCHAR2	(150)
SHIP_LINE_ATTRIBUTE10	VARCHAR2	(150)
SHIP_LINE_ATTRIBUTE11	VARCHAR2	(150)
SHIP_LINE_ATTRIBUTE12	VARCHAR2	(150)
SHIP_LINE_ATTRIBUTE13	VARCHAR2	(150)
SHIP_LINE_ATTRIBUTE14	VARCHAR2	(150)
SHIP_LINE_ATTRIBUTE15	VARCHAR2	(150)
USSGL_TRANSACTION_CODE	VARCHAR2	(30)
GOVERNMENT_CONTEXT	VARCHAR2	(30)
REASON_ID	NUMBER
DESTINATION_CONTEXT	VARCHAR2	(30)
SOURCE_DOC_QUANTITY	NUMBER
SOURCE_DOC_UNIT_OF_MEASURE	VARCHAR2	(25)
MOVEMENT_ID	NUMBER
HEADER_INTERFACE_ID	NUMBER
VENDOR_CUM_SHIPPED_QTY	NUMBER
ITEM_NUM	VARCHAR2	(81)
DOCUMENT_NUM	VARCHAR2	(50)
DOCUMENT_LINE_NUM	VARCHAR2	(50)
TRUCK_NUM	VARCHAR2	(35)
SHIP_TO_LOCATION_CODE	VARCHAR2	(60)
CONTAINER_NUM	VARCHAR2	(35)
SUBSTITUTE_ITEM_NUM	VARCHAR2	(81)
NOTICE_UNIT_PRICE	NUMBER
ITEM_CATEGORY	VARCHAR2	(81)
LOCATION_CODE	VARCHAR2	(60)
VENDOR_NAME	VARCHAR2	(240)
VENDOR_NUM	VARCHAR2	(30)
VENDOR_SITE_CODE	VARCHAR2	(15)
FROM_ORGANIZATION_CODE	VARCHAR2	(3)
TO_ORGANIZATION_CODE	VARCHAR2	(3)
INTRANSIT_OWNING_ORG_CODE	VARCHAR2	(3)
ROUTING_CODE	VARCHAR2	(30)
ROUTING_STEP	VARCHAR2	(30)
RELEASE_NUM	NUMBER
DOCUMENT_SHIPMENT_LINE_NUM	NUMBER
DOCUMENT_DISTRIBUTION_NUM	NUMBER
DELIVER_TO_PERSON_NAME	VARCHAR2	(240)
DELIVER_TO_LOCATION_CODE	VARCHAR2	(60)
USE_MTL_LOT	NUMBER
USE_MTL_SERIAL	NUMBER
LOCATOR	VARCHAR2	(81)
REASON_NAME	VARCHAR2	(30)
VALIDATION_FLAG	VARCHAR2	(1)
SUBSTITUTE_ITEM_ID	NUMBER
QUANTITY_SHIPPED	NUMBER
QUANTITY_INVOICED	NUMBER
TAX_NAME	VARCHAR2	(50)
TAX_AMOUNT	NUMBER
REQ_NUM	VARCHAR2	(25)
REQ_LINE_NUM	NUMBER
REQ_DISTRIBUTION_NUM	NUMBER
WIP_ENTITY_NAME	VARCHAR2	(24)
WIP_LINE_CODE	VARCHAR2	(10)
RESOURCE_CODE	VARCHAR2	(30)
SHIPMENT_LINE_STATUS_CODE	VARCHAR2	(25)
BARCODE_LABEL	VARCHAR2	(35)
TRANSFER_PERCENTAGE	NUMBER
QA_COLLECTION_ID	NUMBER
COUNTRY_OF_ORIGIN_CODE	VARCHAR2	(2)
OE_ORDER_HEADER_ID	NUMBER
OE_ORDER_LINE_ID	NUMBER
CUSTOMER_ID	NUMBER
CUSTOMER_SITE_ID	NUMBER
CUSTOMER_ITEM_NUM	VARCHAR2	(50)
CREATE_DEBIT_MEMO_FLAG	VARCHAR2	(1)
PUT_AWAY_RULE_ID	NUMBER
PUT_AWAY_STRATEGY_ID	NUMBER
LPN_ID	NUMBER
TRANSFER_LPN_ID	NUMBER
COST_GROUP_ID	NUMBER
MOBILE_TXN	VARCHAR2	(2)
MMTT_TEMP_ID	NUMBER
TRANSFER_COST_GROUP_ID	NUMBER
SECONDARY_QUANTITY	NUMBER
SECONDARY_UNIT_OF_MEASURE	VARCHAR2	(25)
SECONDARY_UOM_CODE	VARCHAR2	(3)
QC_GRADE	VARCHAR2	(150)
FROM_LOCATOR	VARCHAR2	(81)
FROM_LOCATOR_ID	NUMBER
PARENT_SOURCE_TRANSACTION_NUM	VARCHAR2	(25)
INTERFACE_AVAILABLE_QTY	NUMBER
INTERFACE_TRANSACTION_QTY	NUMBER
INTERFACE_AVAILABLE_AMT	NUMBER
INTERFACE_TRANSACTION_AMT	NUMBER
LICENSE_PLATE_NUMBER	VARCHAR2	(30)
SOURCE_TRANSACTION_NUM	VARCHAR2	(25)
TRANSFER_LICENSE_PLATE_NUMBER	VARCHAR2	(30)
LPN_GROUP_ID	NUMBER
ORDER_TRANSACTION_ID	NUMBER
CUSTOMER_ACCOUNT_NUMBER	NUMBER
CUSTOMER_PARTY_NAME	VARCHAR2	(360)
OE_ORDER_LINE_NUM	NUMBER
OE_ORDER_NUM	NUMBER
PARENT_INTERFACE_TXN_ID	NUMBER
CUSTOMER_ITEM_ID	NUMBER
AMOUNT	NUMBER
JOB_ID	NUMBER
TIMECARD_ID	NUMBER
TIMECARD_OVN	NUMBER
ERECORD_ID	NUMBER
PROJECT_ID	NUMBER
TASK_ID	NUMBER
ASN_ATTACH_ID	NUMBER
ORG_ID	NUMBER
OPERATING_UNIT	VARCHAR2	(240)
REQUESTED_AMOUNT	NUMBER
MATERIAL_STORED_AMOUNT	NUMBER
AMOUNT_SHIPPED	NUMBER
MATCHING_BASIS	VARCHAR2	(30)
REPLENISH_ORDER_LINE_ID	NUMBER
EXPRESS_TRANSACTION	VARCHAR2	(1)
LCM_SHIPMENT_LINE_ID	NUMBER
UNIT_LANDED_COST	NUMBER
LCM_ADJUSTMENT_NUM	NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT INTERFACE_TRANSACTION_ID
,      GROUP_ID
,      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
,      PROCESSING_STATUS_CODE
,      PROCESSING_MODE_CODE
,      PROCESSING_REQUEST_ID
,      TRANSACTION_STATUS_CODE
,      CATEGORY_ID
,      QUANTITY
,      UNIT_OF_MEASURE
,      INTERFACE_SOURCE_CODE
,      INTERFACE_SOURCE_LINE_ID
,      INV_TRANSACTION_ID
,      ITEM_ID
,      ITEM_DESCRIPTION
,      ITEM_REVISION
,      UOM_CODE
,      EMPLOYEE_ID
,      AUTO_TRANSACT_CODE
,      SHIPMENT_HEADER_ID
,      SHIPMENT_LINE_ID
,      SHIP_TO_LOCATION_ID
,      PRIMARY_QUANTITY
,      PRIMARY_UNIT_OF_MEASURE
,      RECEIPT_SOURCE_CODE
,      VENDOR_ID
,      VENDOR_SITE_ID
,      FROM_ORGANIZATION_ID
,      FROM_SUBINVENTORY
,      TO_ORGANIZATION_ID
,      INTRANSIT_OWNING_ORG_ID
,      ROUTING_HEADER_ID
,      ROUTING_STEP_ID
,      SOURCE_DOCUMENT_CODE
,      PARENT_TRANSACTION_ID
,      PO_HEADER_ID
,      PO_REVISION_NUM
,      PO_RELEASE_ID
,      PO_LINE_ID
,      PO_LINE_LOCATION_ID
,      PO_UNIT_PRICE
,      CURRENCY_CODE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_DATE
,      PO_DISTRIBUTION_ID
,      REQUISITION_LINE_ID
,      REQ_DISTRIBUTION_ID
,      CHARGE_ACCOUNT_ID
,      SUBSTITUTE_UNORDERED_CODE
,      RECEIPT_EXCEPTION_FLAG
,      ACCRUAL_STATUS_CODE
,      INSPECTION_STATUS_CODE
,      INSPECTION_QUALITY_CODE
,      DESTINATION_TYPE_CODE
,      DELIVER_TO_PERSON_ID
,      LOCATION_ID
,      DELIVER_TO_LOCATION_ID
,      SUBINVENTORY
,      LOCATOR_ID
,      WIP_ENTITY_ID
,      WIP_LINE_ID
,      DEPARTMENT_CODE
,      WIP_REPETITIVE_SCHEDULE_ID
,      WIP_OPERATION_SEQ_NUM
,      WIP_RESOURCE_SEQ_NUM
,      BOM_RESOURCE_ID
,      SHIPMENT_NUM
,      FREIGHT_CARRIER_CODE
,      BILL_OF_LADING
,      PACKING_SLIP
,      SHIPPED_DATE
,      EXPECTED_RECEIPT_DATE
,      ACTUAL_COST
,      TRANSFER_COST
,      TRANSPORTATION_COST
,      TRANSPORTATION_ACCOUNT_ID
,      NUM_OF_CONTAINERS
,      WAYBILL_AIRBILL_NUM
,      VENDOR_ITEM_NUM
,      VENDOR_LOT_NUM
,      RMA_REFERENCE
,      COMMENTS
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SHIP_HEAD_ATTRIBUTE_CATEGORY
,      SHIP_HEAD_ATTRIBUTE1
,      SHIP_HEAD_ATTRIBUTE2
,      SHIP_HEAD_ATTRIBUTE3
,      SHIP_HEAD_ATTRIBUTE4
,      SHIP_HEAD_ATTRIBUTE5
,      SHIP_HEAD_ATTRIBUTE6
,      SHIP_HEAD_ATTRIBUTE7
,      SHIP_HEAD_ATTRIBUTE8
,      SHIP_HEAD_ATTRIBUTE9
,      SHIP_HEAD_ATTRIBUTE10
,      SHIP_HEAD_ATTRIBUTE11
,      SHIP_HEAD_ATTRIBUTE12
,      SHIP_HEAD_ATTRIBUTE13
,      SHIP_HEAD_ATTRIBUTE14
,      SHIP_HEAD_ATTRIBUTE15
,      SHIP_LINE_ATTRIBUTE_CATEGORY
,      SHIP_LINE_ATTRIBUTE1
,      SHIP_LINE_ATTRIBUTE2
,      SHIP_LINE_ATTRIBUTE3
,      SHIP_LINE_ATTRIBUTE4
,      SHIP_LINE_ATTRIBUTE5
,      SHIP_LINE_ATTRIBUTE6
,      SHIP_LINE_ATTRIBUTE7
,      SHIP_LINE_ATTRIBUTE8
,      SHIP_LINE_ATTRIBUTE9
,      SHIP_LINE_ATTRIBUTE10
,      SHIP_LINE_ATTRIBUTE11
,      SHIP_LINE_ATTRIBUTE12
,      SHIP_LINE_ATTRIBUTE13
,      SHIP_LINE_ATTRIBUTE14
,      SHIP_LINE_ATTRIBUTE15
,      USSGL_TRANSACTION_CODE
,      GOVERNMENT_CONTEXT
,      REASON_ID
,      DESTINATION_CONTEXT
,      SOURCE_DOC_QUANTITY
,      SOURCE_DOC_UNIT_OF_MEASURE
,      MOVEMENT_ID
,      HEADER_INTERFACE_ID
,      VENDOR_CUM_SHIPPED_QTY
,      ITEM_NUM
,      DOCUMENT_NUM
,      DOCUMENT_LINE_NUM
,      TRUCK_NUM
,      SHIP_TO_LOCATION_CODE
,      CONTAINER_NUM
,      SUBSTITUTE_ITEM_NUM
,      NOTICE_UNIT_PRICE
,      ITEM_CATEGORY
,      LOCATION_CODE
,      VENDOR_NAME
,      VENDOR_NUM
,      VENDOR_SITE_CODE
,      FROM_ORGANIZATION_CODE
,      TO_ORGANIZATION_CODE
,      INTRANSIT_OWNING_ORG_CODE
,      ROUTING_CODE
,      ROUTING_STEP
,      RELEASE_NUM
,      DOCUMENT_SHIPMENT_LINE_NUM
,      DOCUMENT_DISTRIBUTION_NUM
,      DELIVER_TO_PERSON_NAME
,      DELIVER_TO_LOCATION_CODE
,      USE_MTL_LOT
,      USE_MTL_SERIAL
,      LOCATOR
,      REASON_NAME
,      VALIDATION_FLAG
,      SUBSTITUTE_ITEM_ID
,      QUANTITY_SHIPPED
,      QUANTITY_INVOICED
,      TAX_NAME
,      TAX_AMOUNT
,      REQ_NUM
,      REQ_LINE_NUM
,      REQ_DISTRIBUTION_NUM
,      WIP_ENTITY_NAME
,      WIP_LINE_CODE
,      RESOURCE_CODE
,      SHIPMENT_LINE_STATUS_CODE
,      BARCODE_LABEL
,      TRANSFER_PERCENTAGE
,      QA_COLLECTION_ID
,      COUNTRY_OF_ORIGIN_CODE
,      OE_ORDER_HEADER_ID
,      OE_ORDER_LINE_ID
,      CUSTOMER_ID
,      CUSTOMER_SITE_ID
,      CUSTOMER_ITEM_NUM
,      CREATE_DEBIT_MEMO_FLAG
,      PUT_AWAY_RULE_ID
,      PUT_AWAY_STRATEGY_ID
,      LPN_ID
,      TRANSFER_LPN_ID
,      COST_GROUP_ID
,      MOBILE_TXN
,      MMTT_TEMP_ID
,      TRANSFER_COST_GROUP_ID
,      SECONDARY_QUANTITY
,      SECONDARY_UNIT_OF_MEASURE
,      SECONDARY_UOM_CODE
,      QC_GRADE
,      FROM_LOCATOR
,      FROM_LOCATOR_ID
,      PARENT_SOURCE_TRANSACTION_NUM
,      INTERFACE_AVAILABLE_QTY
,      INTERFACE_TRANSACTION_QTY
,      INTERFACE_AVAILABLE_AMT
,      INTERFACE_TRANSACTION_AMT
,      LICENSE_PLATE_NUMBER
,      SOURCE_TRANSACTION_NUM
,      TRANSFER_LICENSE_PLATE_NUMBER
,      LPN_GROUP_ID
,      ORDER_TRANSACTION_ID
,      CUSTOMER_ACCOUNT_NUMBER
,      CUSTOMER_PARTY_NAME
,      OE_ORDER_LINE_NUM
,      OE_ORDER_NUM
,      PARENT_INTERFACE_TXN_ID
,      CUSTOMER_ITEM_ID
,      AMOUNT
,      JOB_ID
,      TIMECARD_ID
,      TIMECARD_OVN
,      ERECORD_ID
,      PROJECT_ID
,      TASK_ID
,      ASN_ATTACH_ID
,      ORG_ID
,      OPERATING_UNIT
,      REQUESTED_AMOUNT
,      MATERIAL_STORED_AMOUNT
,      AMOUNT_SHIPPED
,      MATCHING_BASIS
,      REPLENISH_ORDER_LINE_ID
,      EXPRESS_TRANSACTION
,      LCM_SHIPMENT_LINE_ID
,      UNIT_LANDED_COST
,      LCM_ADJUSTMENT_NUM
FROM PO.RCV_TRANSACTIONS_INTERFACE#;

Dependencies

[top of page]

PO.RCV_TRANSACTIONS_INTERFACE# references the following:

PO: RCV_TRANSACTIONS_INTERFACE

PO.RCV_TRANSACTIONS_INTERFACE# is referenced by following:

APPS: ITG_IP_RCV_TRANS_INTERFACE_ASD; RCV_TRANSACTIONS_INTERFACE