DSD ASN
Hi -
I have inserted an ASN with the below insert query to test the PO with ASN functionality:-
I have inserted an ASN with the below insert query to test the PO with ASN functionality:-
insert into RK_SHIPMENTS (SHIPMENT_ID, SHIPMENT_TYPE, STORE_ID, ASN_ID, FROM_LOCATION_ID, FROM_LOCATION_TYPE, STATUS,
CREATE_DATE, EXPECTED_ARRIVAL_DATE, UPDATE_DATE, COMPLETE_DATE, APPLIED_ASN_ID, ORDER_ID, INVOICE_ID, INVOICE_DATE, EMPLOYEE_ID, COMMENT_DESC,
context_type_id, context_value)values ('100552', 'DSDASN', '452', '100095552', '9906', 'SP', 0, CURRENT_DATE, TRUNC(CURRENT_DATE + 2*4*7, 'DDD'),
null, null, null, '3715', null, null, 'orsimadmin', 'dsdasn comments', null, null);
insert into RK_SHIPMENT_CARTON (ID, SHIPMENT_ID, CARTON_ID, STATUS) values ('5012', '100552', 'DSD.10', 0);
CREATE_DATE, EXPECTED_ARRIVAL_DATE, UPDATE_DATE, COMPLETE_DATE, APPLIED_ASN_ID, ORDER_ID, INVOICE_ID, INVOICE_DATE, EMPLOYEE_ID, COMMENT_DESC,
context_type_id, context_value)values ('100552', 'DSDASN', '452', '100095552', '9906', 'SP', 0, CURRENT_DATE, TRUNC(CURRENT_DATE + 2*4*7, 'DDD'),
null, null, null, '3715', null, null, 'orsimadmin', 'dsdasn comments', null, null);
insert into RK_SHIPMENT_CARTON (ID, SHIPMENT_ID, CARTON_ID, STATUS) values ('5012', '100552', 'DSD.10', 0);
2