Friday 31 October 2014

Oracle Quotation Upload Through Interface(OE_HEADERS_IFACE_ALL and OE_LINES_IFACE_ALL) In R12



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);