[Home] [Help]
3050: OLD_QTY30,OLD_QTY31,OLD_QTY32,OLD_QTY33,OLD_QTY34,OLD_QTY35,
3051: OLD_QTY36,EDITABLE_FLAG,BUCKET_TYPE,PUBLISHER_ID,PUBLISHER_SITE_ID,
3052: next_item,unbucketed_qty)
3053: VALUES
3054: (msc_x_hz_ui_line_id_s.nextval,arg_query_id,nvl(var_relation(i),'NA'),nvl(var_order_relation(i),'NA'),
3055: sys_context('MSC','COMPANY_NAME'),var_customer_org(i), var_item_name(i),
3056: var_item_name_desc(i),v_o_forecast, ORDER_FORECAST_CST, v_name,
3057: var_tp_uom(i), var_supplier(i), var_customer(i), var_supplier_org(i),
3058: var_customer_org(i),var_supplier_id(i),var_customer_id(i),
3158: OLD_QTY30,OLD_QTY31,OLD_QTY32,OLD_QTY33,OLD_QTY34,OLD_QTY35,
3159: OLD_QTY36,EDITABLE_FLAG,BUCKET_TYPE,PUBLISHER_ID,PUBLISHER_SITE_ID,
3160: next_item, unbucketed_qty)
3161: VALUES
3162: (msc_x_hz_ui_line_id_s.nextval,arg_query_id,nvl(var_relation(i),'NA'),nvl(var_order_relation(i),'NA'),
3163: sys_context('MSC','COMPANY_NAME'),var_supplier_org(i), var_item_name(i),
3164: var_item_name_desc(i),v_o_supply_commit, SUPPLY_COMMIT, v_name,
3165: var_tp_uom(i),var_supplier(i),var_customer(i),var_supplier_org(i),
3166: var_customer_org(i),var_supplier_id(i),var_customer_id(i),
3290: OLD_QTY24,OLD_QTY25,OLD_QTY26,OLD_QTY27,OLD_QTY28,OLD_QTY29,
3291: OLD_QTY30,OLD_QTY31,OLD_QTY32,OLD_QTY33,OLD_QTY34,OLD_QTY35,
3292: OLD_QTY36,EDITABLE_FLAG)
3293: VALUES
3294: (msc_x_hz_ui_line_id_s.nextval,arg_query_id,nvl(var_relation(i),'NA'),nvl(var_order_relation(i),'NA'),
3295: nvl(var_from_co_name(i),'NA'),var_from_org_name(i),var_item_name(i),
3296: var_item_name_desc(i),0,v_order ,v_name,var_uom(i),
3297: var_supplier(i),var_customer(i),var_supplier_org(i),
3298: var_customer_org(i),var_supplier_id(i),var_customer_id(i),
3457: OLD_QTY24,OLD_QTY25,OLD_QTY26,OLD_QTY27,OLD_QTY28,OLD_QTY29,
3458: OLD_QTY30,OLD_QTY31,OLD_QTY32,OLD_QTY33,OLD_QTY34,OLD_QTY35,
3459: OLD_QTY36,EDITABLE_FLAG)
3460: VALUES
3461: (msc_x_hz_ui_line_id_s.nextval,arg_query_id,'NA',nvl(var_order_relation(i),'NA'),
3462: nvl(var_from_co_name(i),'NA'),var_from_org_name(i),var_item_name(i),
3463: var_item_name_desc(i),39,-1,v_calculation_name,var_uom(i),var_supplier(i),
3464: var_customer(i),var_supplier_org(i),var_customer_org(i),
3465: var_supplier_id(i),var_customer_id(i),'NA',
3829: OLD_QTY24,OLD_QTY25,OLD_QTY26,OLD_QTY27,OLD_QTY28,OLD_QTY29,
3830: OLD_QTY30,OLD_QTY31,OLD_QTY32,OLD_QTY33,OLD_QTY34,OLD_QTY35,
3831: OLD_QTY36,EDITABLE_FLAG)
3832: VALUES
3833: (msc_x_hz_ui_line_id_s.nextval,arg_query_id,'NA',nvl(var_order_relation(i),'NA'),
3834: nvl(var_from_co_name(i),'NA'),var_from_org_name(i),var_item_name(i),
3835: var_item_name_desc(i),41,-1,v_calculation_name,var_uom(i),var_supplier(i),
3836: var_customer(i),var_supplier_org(i),var_customer_org(i),
3837: var_supplier_id(i),var_customer_id(i),'NA',
3913: OLD_QTY24,OLD_QTY25,OLD_QTY26,OLD_QTY27,OLD_QTY28,OLD_QTY29,
3914: OLD_QTY30,OLD_QTY31,OLD_QTY32,OLD_QTY33,OLD_QTY34,OLD_QTY35,
3915: OLD_QTY36,EDITABLE_FLAG)
3916: VALUES
3917: (msc_x_hz_ui_line_id_s.nextval,arg_query_id,nvl(var_relation(i),'NA'),nvl(var_order_relation(i),'NA'),
3918: nvl(var_from_co_name(i),'NA'),var_from_org_name(i),var_item_name(i),
3919: var_item_name_desc(i),40,-1,v_name,var_uom(i),var_supplier(i),
3920: var_customer(i),var_supplier_org(i),var_customer_org(i),
3921: var_supplier_id(i),var_customer_id(i),var_supplier_site_id(i),
4357: OLD_QTY24,OLD_QTY25,OLD_QTY26,OLD_QTY27,OLD_QTY28,OLD_QTY29,
4358: OLD_QTY30,OLD_QTY31,OLD_QTY32,OLD_QTY33,OLD_QTY34,OLD_QTY35,OLD_QTY36,
4359: BUCKET_TYPE,PUBLISHER_ID,PUBLISHER_SITE_ID,NEXT_ITEM,SUP_ITEM)
4360: VALUES
4361: (msc_x_hz_ui_line_id_s.nextval,arg_query_id,var_relation(i),var_order_relation(i),
4362: var_from_co_name(i),var_from_org_name(i),var_item_name(i),
4363: var_item_name_desc(i),var_supplier(i),var_customer(i),
4364: var_supplier_org(i),var_customer_org(i),var_order_rank(i),
4365: var_order(i),var_order_desc(i),var_ship_ctrl(i),var_uom(i),var_supplier_id(i),