INSERT INTO OE_HEADERS_IFACE_ALL
(ORIG_SYS_DOCUMENT_REF,
ORDER_SOURCE_ID,
CONVERSION_RATE,
ORG_ID,
ORDER_TYPE_ID,
PRICE_LIST_ID,
SOLD_FROM_ORG_ID,
SOLD_TO_ORG_ID,
SHIP_TO_ORG_ID,
SHIP_FROM_ORG_ID,
CUSTOMER_NAME,
INVOICE_TO_ORG_ID,
OPERATION_CODE,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
BOOKED_FLAG,
SHIPPING_METHOD,
FREIGHT_TERMS_CODE,
TRANSACTIONAL_CURR,
TRANSACTION_PHASE_CODE --Specially For Quotation
)
VALUES
( '3',
0,
NULL,
ORG_ID,
ORDER_TYPE_ID,
PRICE_LIST_ID,
NULL,
SOLD_TO_ORG_ID,
SHIP_TO_ORG_ID,
SHIP_FROM_ORG_ID,
CUSTOMER_NAME
INVOICE_TO_ORG_ID,
OPERATION_CODE,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
BOOKED_FLAG,
NULL,
NULL,
TRANSACTIONAL_CURR ,
'N' --Specially For Quotation
);
INSERT INTO OE_LINES_IFACE_ALL
( ORDER_SOURCE_ID,
ORIG_SYS_DOCUMENT_REF,
ORIG_SYS_LINE_REF,
ORIG_SYS_SHIPMENT_REF,
INVENTORY_ITEM_ID,
LINK_TO_LINE_REF,
REQUEST_DATE,
SCHEDULE_SHIP_DATE ,
DELIVERY_LEAD_TIME,
DELIVERY_ID,
ORDERED_QUANTITY,
ORDER_QUANTITY_UOM,
SHIPPING_QUANTITY,
PRICING_QUANTITY,
PRICING_QUANTITY_UOM,
SOLD_FROM_ORG_ID,
SOLD_TO_ORG_ID,
INVOICE_TO_ORG_ID,
SHIP_TO_ORG_ID,
PRICE_LIST_ID,
PAYMENT_TERM_ID,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
SUBINVENTORY,
UNIT_SELLING_PRICE,
SHIPPING_METHOD)
VALUES
( ORDER_SOURCE_ID,
ORIG_SYS_DOCUMENT_REF,
ORIG_SYS_LINE_REF,
NULL,
INVENTORY_ITEM_ID,
NULL,
REQUEST_DATE,
SCHEDULE_SHIP_DATE,
DELIVERY_LEAD_TIME,
NULL,
ORDERED_QUANTITY,
ORDER_QUANTITY_UOM,
NULL,
NULL,
NULL,
NULL,
SOLD_TO_ORG_ID,
INVOICE_TO_ORG_ID,
SHIP_TO_ORG_ID,
V_PRICE_LIST_ID,
V_PAYMENT_TERM_ID,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
NULL,
UNIT_SELLING_PRICE,
NULL);
No comments:
Post a Comment