[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),
3289: OLD_QTY24,OLD_QTY25,OLD_QTY26,OLD_QTY27,OLD_QTY28,OLD_QTY29,
3290: OLD_QTY30,OLD_QTY31,OLD_QTY32,OLD_QTY33,OLD_QTY34,OLD_QTY35,
3291: OLD_QTY36,EDITABLE_FLAG)
3292: VALUES
3293: (msc_x_hz_ui_line_id_s.nextval,arg_query_id,nvl(var_relation(i),'NA'),nvl(var_order_relation(i),'NA'),
3294: nvl(var_from_co_name(i),'NA'),var_from_org_name(i),var_item_name(i),
3295: var_item_name_desc(i),0,v_order ,v_name,var_uom(i),
3296: var_supplier(i),var_customer(i),var_supplier_org(i),
3297: var_customer_org(i),var_supplier_id(i),var_customer_id(i),
3456: OLD_QTY24,OLD_QTY25,OLD_QTY26,OLD_QTY27,OLD_QTY28,OLD_QTY29,
3457: OLD_QTY30,OLD_QTY31,OLD_QTY32,OLD_QTY33,OLD_QTY34,OLD_QTY35,
3458: OLD_QTY36,EDITABLE_FLAG)
3459: VALUES
3460: (msc_x_hz_ui_line_id_s.nextval,arg_query_id,'NA',nvl(var_order_relation(i),'NA'),
3461: nvl(var_from_co_name(i),'NA'),var_from_org_name(i),var_item_name(i),
3462: var_item_name_desc(i),39,-1,v_calculation_name,var_uom(i),var_supplier(i),
3463: var_customer(i),var_supplier_org(i),var_customer_org(i),
3464: var_supplier_id(i),var_customer_id(i),'NA',
3828: OLD_QTY24,OLD_QTY25,OLD_QTY26,OLD_QTY27,OLD_QTY28,OLD_QTY29,
3829: OLD_QTY30,OLD_QTY31,OLD_QTY32,OLD_QTY33,OLD_QTY34,OLD_QTY35,
3830: OLD_QTY36,EDITABLE_FLAG)
3831: VALUES
3832: (msc_x_hz_ui_line_id_s.nextval,arg_query_id,'NA',nvl(var_order_relation(i),'NA'),
3833: nvl(var_from_co_name(i),'NA'),var_from_org_name(i),var_item_name(i),
3834: var_item_name_desc(i),41,-1,v_calculation_name,var_uom(i),var_supplier(i),
3835: var_customer(i),var_supplier_org(i),var_customer_org(i),
3836: var_supplier_id(i),var_customer_id(i),'NA',
3912: OLD_QTY24,OLD_QTY25,OLD_QTY26,OLD_QTY27,OLD_QTY28,OLD_QTY29,
3913: OLD_QTY30,OLD_QTY31,OLD_QTY32,OLD_QTY33,OLD_QTY34,OLD_QTY35,
3914: OLD_QTY36,EDITABLE_FLAG)
3915: VALUES
3916: (msc_x_hz_ui_line_id_s.nextval,arg_query_id,nvl(var_relation(i),'NA'),nvl(var_order_relation(i),'NA'),
3917: nvl(var_from_co_name(i),'NA'),var_from_org_name(i),var_item_name(i),
3918: var_item_name_desc(i),40,-1,v_name,var_uom(i),var_supplier(i),
3919: var_customer(i),var_supplier_org(i),var_customer_org(i),
3920: var_supplier_id(i),var_customer_id(i),var_supplier_site_id(i),
4356: OLD_QTY24,OLD_QTY25,OLD_QTY26,OLD_QTY27,OLD_QTY28,OLD_QTY29,
4357: OLD_QTY30,OLD_QTY31,OLD_QTY32,OLD_QTY33,OLD_QTY34,OLD_QTY35,OLD_QTY36,
4358: BUCKET_TYPE,PUBLISHER_ID,PUBLISHER_SITE_ID,NEXT_ITEM,SUP_ITEM)
4359: VALUES
4360: (msc_x_hz_ui_line_id_s.nextval,arg_query_id,var_relation(i),var_order_relation(i),
4361: var_from_co_name(i),var_from_org_name(i),var_item_name(i),
4362: var_item_name_desc(i),var_supplier(i),var_customer(i),
4363: var_supplier_org(i),var_customer_org(i),var_order_rank(i),
4364: var_order(i),var_order_desc(i),var_ship_ctrl(i),var_uom(i),var_supplier_id(i),