hi all, I need your help
I have a query like below,
INSERT INTO RCV_TRANSACTIONS_INTERFACE
(INTERFACE_TRANSACTION_ID,
GROUP_ID,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_LOGIN,
TRANSACTION_TYPE,
TRANSACTION_DATE,
PROCESSING_STATUS_CODE,
PROCESSING_MODE_CODE,
TRANSACTION_STATUS_CODE,
QUANTITY,
UNIT_OF_MEASURE,
INTERFACE_SOURCE_CODE,
ITEM_ID,
ITEM_DESCRIPTION,
EMPLOYEE_ID,
AUTO_TRANSACT_CODE,
--SHIPMENT_HEADER_ID,
--SHIPMENT_LINE_ID,
RECEIPT_SOURCE_CODE,
TO_ORGANIZATION_ID,
SOURCE_DOCUMENT_CODE,
DESTINATION_TYPE_CODE,
SUBINVENTORY,
LOCATOR_ID,
--SHIPMENT_NUM,
EXPECTED_RECEIPT_DATE,
HEADER_INTERFACE_ID,
VALIDATION_FLAG,
CUSTOMER_ID,
CUSTOMER_SITE_ID,
OE_ORDER_HEADER_ID,
OE_ORDER_LINE_ID,
LOCATION_ID,
DELIVER_TO_LOCATION_ID,
)
VALUES
( RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL, -- INTERFACE_TRANSACTION_ID
RCV_INTERFACE_GROUPS_S.CURRVAL, --GROUP_ID
SYSDATE, --LAST_UPDATE_DATE
0, --LAST_UPDATED_BY
SYSDATE, --CREATION_DATE
0, --CREATED_BY
0, --LAST_UPDATE_LOGIN
'RECEIVE', --TRANSACTION_TYPE
SYSDATE, --TRANSACTION_DATE
'PENDING', --PROCESSING_STATUS_CODE
'BATCH', --PROCESSING_MODE_CODE
'PENDING', --TRANSACTION_STATUS_CODE
XX.QUANTITY, --QUANTITY
XX.PRIMARY_UNIT_OF_MEASURE, --XX.PRIMARY_UOM, --UNIT_OF_MEASURE
'RCV', --INTERFACE_SOURCE_CODE
XX.ITEM_ID, --ITEM_ID
XX.ITEM_DESCRIPTION,
V_EMPLOYEE_ID, --EMPLOYEE_ID
'DELIVER', --AUTO_TRANSACT_CODE
--X.SHIPMENT_HEADER_ID, --SHIPMENT_HEADER_ID
--X.SHIPMENT_LINE_ID, --SHIPMENT_LINE_ID
'CUSTOMER', --RECEIPT_SOURCE_CODE
XX.ORGANIZATION_ID, --PENERIMA, --TO_ORGANIZATION_ID
'RMA', --SOURCE_DOCUMENT_CODE
'INVENTORY', --DESTINATION_TYPE_CODE
XX.SUBINVENTORY, --SUBINVENTORY
XX.LOCATOR_ID,
--X.SHIPMENT_NUM, --SHIPMENT_NUM
SYSDATE, --EXPECTED_RECEIPT_DATE,
RCV_HEADERS_INTERFACE_S.CURRVAL, --HEADER_INTERFACE_ID
'Y' , --VALIDATION_FLAG
XX.CUSTOMER_ID,
XX.SHIP_TO_ID,
X.OE_HEADER_ID,
V_OE_ORDER_LINE_ID,
V_LOCATION_ID,
V_LOCATION_ID,
XX.REASON_ID
)
than I submit request RVCTP (Receiving Transaction Processor)
when I select from table RCV_SHIPMENT_LINES, the column ITEM_DESCRIPTION, there is something wrong, the value on column is a number
and the value is minus ( -5 )
any body can help?