查找 Group_id
Select * from RCV_TRANSACTIONS_INTERFACE where PO_HEADER_ID=883313; Select * from RCV_HEADERS_INTERFACE where HEADER_INTERFACE_ID=4145843;
2. Correction for Lot & Serial controlled item --Note: 335699.1
3. ASN
4. LCM
5. RMA
ROI脚本(二)
MATERIAL_TRANSACTIONS_S.NEXTVAL,
'RCV',
RCV_TRANSACTIONS_INTERFACE_S.CURRVAL
);
INSERT INTO MTL_SERIAL_NUMBERS_INTERFACE
( TRANSACTION_INTERFACE_ID,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_LOGIN,
FM_SERIAL_NUMBER,
TO_SERIAL_NUMBER,
PRODUCT_CODE,
PRODUCT_TRANSACTION_ID)
VALUES
(MTL_MATERIAL_TRANSACTIONS_S.CURRVAL,
SYSDATE,
0,
SYSDATE,
0,
0,
'S-1000', --FM_SERIAL_NUMBER
'S-1049', --TO_SERIAL_NUMBER
'RCV',
RCV_TRANSACTIONS_INTERFACE_S.CURRVAL );
Commit;