eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_X_HZ_PLAN dependencies on MSC_HZ_UI_LINES

Line 574: FROM msc_hz_ui_lines

570: ROUND( sum(QTY_BUCKET26), 6) q_26,ROUND( sum(QTY_BUCKET27), 6) q_27,ROUND( sum(QTY_BUCKET28), 6) q_28,
571: ROUND( sum(QTY_BUCKET29), 6) q_29,ROUND( sum(QTY_BUCKET30), 6) q_30,ROUND( sum(QTY_BUCKET31), 6) q_31,
572: ROUND( sum(QTY_BUCKET32), 6) q_32,ROUND( sum(QTY_BUCKET33), 6) q_33,ROUND( sum(QTY_BUCKET34), 6) q_34,
573: ROUND( sum(QTY_BUCKET35), 6) q_35,ROUND( sum(QTY_BUCKET36), 6) q_36
574: FROM msc_hz_ui_lines
575: WHERE ORDER_TYPE = nvl(arg_order_type,NOT_SELECTED)
576: AND query_id = arg_query_id
577: GROUP BY RELATION_GROUP,ORDER_RELATION_GROUP, FROM_COMPANY_NAME,FROM_ORG_CODE,ITEM_NAME,ITEM_DESCRIPTION,
578: SUPPLIER_NAME,CUSTOMER_NAME,SUPPLIER_ORG_CODE,CUSTOMER_ORG_CODE,UOM,

Line 710: FROM msc_hz_ui_lines

706: +QTY_BUCKET14+QTY_BUCKET15+QTY_BUCKET16+QTY_BUCKET17+QTY_BUCKET18+QTY_BUCKET19
707: +QTY_BUCKET20+QTY_BUCKET21+QTY_BUCKET22+QTY_BUCKET23+QTY_BUCKET24+QTY_BUCKET25
708: +QTY_BUCKET26+QTY_BUCKET27+QTY_BUCKET28+QTY_BUCKET29+QTY_BUCKET30+QTY_BUCKET31
709: +QTY_BUCKET32+QTY_BUCKET33+QTY_BUCKET34+QTY_BUCKET35+QTY_BUCKET36), 6) q_36
710: FROM msc_hz_ui_lines
711: WHERE ORDER_TYPE = nvl(arg_order_type,NOT_SELECTED)
712: AND query_id = arg_query_id
713: GROUP BY RELATION_GROUP, ORDER_RELATION_GROUP, FROM_COMPANY_NAME,FROM_ORG_CODE,ITEM_NAME,ITEM_DESCRIPTION,
714: SUPPLIER_NAME,CUSTOMER_NAME,SUPPLIER_ORG_CODE,CUSTOMER_ORG_CODE,UOM,

Line 2987: FROM msc_hz_ui_lines a

2983: var_customer_site_id, var_supplier, var_customer, var_supplier_org,
2984: var_customer_org, var_order_rank, var_uom, var_cust_item, var_sup_item,
2985: var_cust_item_desc, var_sup_item_desc, var_tp_uom, var_owner_item,
2986: var_owner_item_desc
2987: FROM msc_hz_ui_lines a
2988: WHERE a.query_id = arg_query_id
2989: AND a.order_type = SUPPLY_COMMIT
2990: AND a.customer_id = sys_context('MSC','COMPANY_ID')
2991: AND a.bucket_type <> 0

Line 3031: INSERT INTO msc_hz_ui_lines

3027: end if;
3028:
3029: forall i in var_relation.FIRST..var_relation.LAST
3030:
3031: INSERT INTO msc_hz_ui_lines
3032: (LINE_ID,QUERY_ID,RELATION_GROUP,ORDER_RELATION_GROUP,FROM_COMPANY_NAME,FROM_ORG_CODE,
3033: ITEM_NAME,ITEM_DESCRIPTION,ORDER_TYPE_RANK,ORDER_TYPE,ORDER_TYPE_DESC,
3034: UOM,SUPPLIER_NAME,CUSTOMER_NAME,SUPPLIER_ORG_CODE,CUSTOMER_ORG_CODE,
3035: SUPPLIER_ID,CUSTOMER_ID,SUPPLIER_SITE_ID,CUSTOMER_SITE_ID,

Line 3097: FROM msc_hz_ui_lines a

3093: var_customer_site_id, var_supplier, var_customer, var_supplier_org,
3094: var_customer_org, var_order_rank, var_uom, var_cust_item, var_sup_item,
3095: var_cust_item_desc, var_sup_item_desc, var_tp_uom, var_owner_item,
3096: var_owner_item_desc
3097: FROM msc_hz_ui_lines a
3098: WHERE a.query_id = arg_query_id
3099: AND a.order_type = ORDER_FORECAST_CST
3100: AND a.supplier_id = sys_context('MSC','COMPANY_ID')
3101: AND a.bucket_type <> 0

Line 3139: INSERT INTO msc_hz_ui_lines

3135: v_next_item := 2;
3136: end if;
3137:
3138: forall i in var_relation.FIRST..var_relation.LAST
3139: INSERT INTO msc_hz_ui_lines
3140: (LINE_ID,QUERY_ID,RELATION_GROUP,ORDER_RELATION_GROUP,FROM_COMPANY_NAME,FROM_ORG_CODE,
3141: ITEM_NAME,ITEM_DESCRIPTION,ORDER_TYPE_RANK,ORDER_TYPE,ORDER_TYPE_DESC,
3142: UOM,SUPPLIER_NAME,CUSTOMER_NAME,SUPPLIER_ORG_CODE,CUSTOMER_ORG_CODE,
3143: SUPPLIER_ID,CUSTOMER_ID,SUPPLIER_SITE_ID,CUSTOMER_SITE_ID,

Line 3217: FROM msc_hz_ui_lines a

3213: var_line_id num;
3214: BEGIN
3215: SELECT a.inventory_item_id, a.line_id
3216: BULK COLLECT INTO var_item_id, var_line_id
3217: FROM msc_hz_ui_lines a
3218: WHERE a.query_id = arg_query_id
3219: ORDER BY item_name, order_relation_group, order_type_rank ;
3220:
3221: FOR i in var_item_id.FIRST..var_item_id.LAST loop

Line 3237: UPDATE msc_hz_ui_lines

3233: END LOOP;
3234:
3235: -- now do bulk update
3236: FORALL i in var_line_id.FIRST..var_line_id.LAST
3237: UPDATE msc_hz_ui_lines
3238: SET next_item = var_next_item(i)
3239: WHERE query_id = arg_query_id
3240: AND line_id = var_line_id(i);
3241: EXCEPTION

Line 3273: INSERT INTO msc_hz_ui_lines

3269: CLOSE c_total;
3270:
3271: if var_relation is not null and var_relation.COUNT > 0 then
3272: FORALL i IN var_relation.FIRST..var_relation.LAST
3273: INSERT INTO msc_hz_ui_lines
3274: (LINE_ID,QUERY_ID,RELATION_GROUP,ORDER_RELATION_GROUP,FROM_COMPANY_NAME,FROM_ORG_CODE,
3275: ITEM_NAME,ITEM_DESCRIPTION,ORDER_TYPE_RANK,ORDER_TYPE,ORDER_TYPE_DESC,
3276: UOM,SUPPLIER_NAME,CUSTOMER_NAME,SUPPLIER_ORG_CODE,CUSTOMER_ORG_CODE,
3277: SUPPLIER_ID,CUSTOMER_ID,SUPPLIER_SITE_ID,CUSTOMER_SITE_ID,INVENTORY_ITEM_ID,

Line 3330: UPDATE msc_hz_ui_lines

3326:
3327: PROCEDURE invert_quantities(arg_query_id NUMBER, p_order_type NUMBER)
3328: IS
3329: BEGIN
3330: UPDATE msc_hz_ui_lines
3331: SET UNBUCKETED_QTY = -UNBUCKETED_QTY,
3332: QTY_BUCKET1 = -QTY_BUCKET1,
3333: QTY_BUCKET2 = -QTY_BUCKET2,
3334: QTY_BUCKET3 = -QTY_BUCKET3,

Line 3377: DELETE FROM msc_hz_ui_lines

3373: PROCEDURE delete_order_type(arg_query_id NUMBER, p_order_type NUMBER)
3374: IS
3375: BEGIN
3376:
3377: DELETE FROM msc_hz_ui_lines
3378: WHERE order_type = p_order_type
3379: AND query_id = arg_query_id;
3380:
3381: EXCEPTION

Line 3408: FROM msc_hz_ui_lines

3404: ROUND( sum(QTY_BUCKET26), 6) q_26,ROUND( sum(QTY_BUCKET27), 6) q_27,ROUND( sum(QTY_BUCKET28), 6) q_28,
3405: ROUND( sum(QTY_BUCKET29), 6) q_29,ROUND( sum(QTY_BUCKET30), 6) q_30,ROUND( sum(QTY_BUCKET31), 6) q_31,
3406: ROUND( sum(QTY_BUCKET32), 6) q_32,ROUND( sum(QTY_BUCKET33), 6) q_33,ROUND( sum(QTY_BUCKET34), 6) q_34,
3407: ROUND( sum(QTY_BUCKET35), 6) q_35,ROUND( sum(QTY_BUCKET36), 6) q_36
3408: FROM msc_hz_ui_lines
3409: WHERE ORDER_TYPE IN (ORDER_FORECAST_CST, REQUISITION,PURCHASE_ORDER)
3410: AND query_id = arg_query_id
3411: GROUP BY ORDER_RELATION_GROUP, FROM_COMPANY_NAME,FROM_ORG_CODE,ITEM_NAME,ITEM_DESCRIPTION,
3412: SUPPLIER_NAME,CUSTOMER_NAME,SUPPLIER_ORG_CODE,CUSTOMER_ORG_CODE,UOM,

Line 3440: INSERT INTO msc_hz_ui_lines

3436: invert_quantities(arg_query_id, PURCHASE_ORDER);
3437:
3438: if var_order_relation is not null and var_order_relation.COUNT > 0 then
3439: FORALL i IN var_order_relation.FIRST..var_order_relation.LAST
3440: INSERT INTO msc_hz_ui_lines
3441: (LINE_ID,QUERY_ID,RELATION_GROUP,ORDER_RELATION_GROUP,FROM_COMPANY_NAME,FROM_ORG_CODE,
3442: ITEM_NAME,ITEM_DESCRIPTION,ORDER_TYPE_RANK,ORDER_TYPE,ORDER_TYPE_DESC,
3443: UOM,SUPPLIER_NAME,CUSTOMER_NAME,SUPPLIER_ORG_CODE,CUSTOMER_ORG_CODE,
3444: SUPPLIER_ID,CUSTOMER_ID,SUPPLIER_SITE_ID,CUSTOMER_SITE_ID,INVENTORY_ITEM_ID,

Line 3787: FROM msc_hz_ui_lines

3783: ROUND( sum(QTY_BUCKET26), 6) q_26,ROUND( sum(QTY_BUCKET27), 6) q_27,ROUND( sum(QTY_BUCKET28), 6) q_28,
3784: ROUND( sum(QTY_BUCKET29), 6) q_29,ROUND( sum(QTY_BUCKET30), 6) q_30,ROUND( sum(QTY_BUCKET31), 6) q_31,
3785: ROUND( sum(QTY_BUCKET32), 6) q_32,ROUND( sum(QTY_BUCKET33), 6) q_33,ROUND( sum(QTY_BUCKET34), 6) q_34,
3786: ROUND( sum(QTY_BUCKET35), 6) q_35,ROUND( sum(QTY_BUCKET36), 6) q_36
3787: FROM msc_hz_ui_lines
3788: WHERE ORDER_TYPE IN (SUPPLY_COMMIT,SALES_ORDER)
3789: AND query_id = arg_query_id
3790: GROUP BY ORDER_RELATION_GROUP, FROM_COMPANY_NAME,FROM_ORG_CODE,ITEM_NAME,ITEM_DESCRIPTION,
3791: SUPPLIER_NAME,CUSTOMER_NAME,SUPPLIER_ORG_CODE,CUSTOMER_ORG_CODE,UOM,

Line 3812: INSERT INTO msc_hz_ui_lines

3808: CLOSE c_total_supply;
3809:
3810: IF var_order_relation is not null and var_order_relation.COUNT > 0 THEN
3811: FORALL i IN var_order_relation.FIRST..var_order_relation.LAST
3812: INSERT INTO msc_hz_ui_lines
3813: (LINE_ID,QUERY_ID,RELATION_GROUP,ORDER_RELATION_GROUP,FROM_COMPANY_NAME,FROM_ORG_CODE,
3814: ITEM_NAME,ITEM_DESCRIPTION,ORDER_TYPE_RANK,ORDER_TYPE,ORDER_TYPE_DESC,
3815: UOM,SUPPLIER_NAME,CUSTOMER_NAME,SUPPLIER_ORG_CODE,CUSTOMER_ORG_CODE,
3816: SUPPLIER_ID,CUSTOMER_ID,SUPPLIER_SITE_ID,CUSTOMER_SITE_ID,INVENTORY_ITEM_ID,

Line 3896: INSERT INTO msc_hz_ui_lines

3892: CLOSE c_runTotal;
3893:
3894: if var_relation is not null and var_relation.COUNT > 0 then
3895: FORALL i IN var_relation.FIRST..var_relation.LAST
3896: INSERT INTO msc_hz_ui_lines
3897: (LINE_ID,QUERY_ID,RELATION_GROUP,ORDER_RELATION_GROUP,FROM_COMPANY_NAME,FROM_ORG_CODE,
3898: ITEM_NAME,ITEM_DESCRIPTION,ORDER_TYPE_RANK,ORDER_TYPE,ORDER_TYPE_DESC,
3899: UOM,SUPPLIER_NAME,CUSTOMER_NAME,SUPPLIER_ORG_CODE,CUSTOMER_ORG_CODE,
3900: SUPPLIER_ID,CUSTOMER_ID,SUPPLIER_SITE_ID,CUSTOMER_SITE_ID,INVENTORY_ITEM_ID,

Line 4339: INSERT INTO msc_hz_ui_lines

4335: BEGIN
4336: if var_relation is not null and var_relation.COUNT > 0 then
4337: i := 0;
4338: FORALL i IN var_relation.FIRST..var_relation.LAST
4339: INSERT INTO msc_hz_ui_lines
4340: (LINE_ID,QUERY_ID,RELATION_GROUP,ORDER_RELATION_GROUP,FROM_COMPANY_NAME,FROM_ORG_CODE,
4341: ITEM_NAME,ITEM_DESCRIPTION,SUPPLIER_NAME,CUSTOMER_NAME,
4342: SUPPLIER_ORG_CODE,CUSTOMER_ORG_CODE,ORDER_TYPE_RANK,
4343: ORDER_TYPE,ORDER_TYPE_DESC,shipping_control,UOM,SUPPLIER_ID,CUSTOMER_ID,

Line 4395: FROM msc_hz_ui_lines

4391: END ;
4392:
4393: SELECT count(*)
4394: INTO arg_num_rowset
4395: FROM msc_hz_ui_lines
4396: WHERE query_id = arg_query_id
4397: AND order_type_desc <> fnd_message.get_string('MSC','MSC_X_HZ_RUN_DEMAND')
4398: AND order_type_desc <> fnd_message.get_string('MSC','MSC_X_HZ_RUN_SUPPLY')
4399: ;

Line 4412: FROM msc_hz_ui_lines

4408: SELECT line_id, customer_name,supplier_name,inventory_item_id,
4409: order_type,from_company_name
4410: BULK COLLECT INTO v_line_id, v_cust_name, v_sup_name,
4411: v_item_id,v_order,v_pub_name
4412: FROM msc_hz_ui_lines
4413: WHERE editable_flag = 0
4414: AND query_id = arg_query_id -- this is required to avoid the comp row disappearing act.
4415: OR order_type in (ORDER_FORECAST_CST, SUPPLY_COMMIT) ;
4416:

Line 4462: UPDATE msc_hz_ui_lines

4458:
4459: if var_line_id.COUNT > 0 then
4460:
4461: FORALL k in var_line_id.FIRST..var_line_id.LAST
4462: UPDATE msc_hz_ui_lines
4463: SET owner_item = var_owner_item(k),
4464: cust_item = var_cust_item(k),
4465: sup_item = var_sup_item(k),
4466: owner_item_desc = var_owner_item_desc(k),

Line 4488: FROM msc_hz_ui_lines

4484:
4485:
4486: SELECT count(*)
4487: INTO arg_num_rowset
4488: FROM msc_hz_ui_lines
4489: WHERE query_id = arg_query_id
4490: AND order_type_desc <> fnd_message.get_string('MSC','MSC_X_HZ_RUN_DEMAND')
4491: AND order_type_desc <> fnd_message.get_string('MSC','MSC_X_HZ_RUN_SUPPLY')
4492: ;

Line 4518: FROM msc_hz_ui_lines

4514:
4515:
4516: SELECT count(*)
4517: INTO arg_num_rowset
4518: FROM msc_hz_ui_lines
4519: WHERE query_id = arg_query_id
4520: AND order_type_desc <> fnd_message.get_string('MSC','MSC_X_HZ_RUN_DEMAND')
4521: AND order_type_desc <> fnd_message.get_string('MSC','MSC_X_HZ_RUN_SUPPLY')
4522: ;

Line 4537: UPDATE msc_hz_ui_lines

4533:
4534: -- remove site if agg is at company level
4535: if myco_agg = COMPANY_AGG and tpco_AGG = COMPANY_AGG then
4536:
4537: UPDATE msc_hz_ui_lines
4538: SET FROM_ORG_CODE = null,SUPPLIER_ORG_CODE = NULL,
4539: CUSTOMER_ORG_CODE = NULL
4540: WHERE query_id = arg_query_id ;
4541: end if;

Line 4545: UPDATE msc_hz_ui_lines

4541: end if;
4542:
4543: if myco_agg = COMPANY_AGG and tpco_AGG = ORG_AGG then
4544: -- delete site only where user co id is not the id
4545: UPDATE msc_hz_ui_lines
4546: SET FROM_ORG_CODE = null
4547: WHERE FROM_COMPANY_NAME = v_user_company
4548: AND query_id = arg_query_id ;
4549:

Line 4550: UPDATE msc_hz_ui_lines

4546: SET FROM_ORG_CODE = null
4547: WHERE FROM_COMPANY_NAME = v_user_company
4548: AND query_id = arg_query_id ;
4549:
4550: UPDATE msc_hz_ui_lines
4551: SET SUPPLIER_ORG_CODE = null
4552: WHERE SUPPLIER_NAME = v_user_company -- user is the supplier
4553: AND query_id = arg_query_id ;
4554:

Line 4555: UPDATE msc_hz_ui_lines

4551: SET SUPPLIER_ORG_CODE = null
4552: WHERE SUPPLIER_NAME = v_user_company -- user is the supplier
4553: AND query_id = arg_query_id ;
4554:
4555: UPDATE msc_hz_ui_lines
4556: SET CUSTOMER_ORG_CODE = null
4557: WHERE CUSTOMER_NAME = v_user_company -- user is the customer
4558: AND query_id = arg_query_id ;
4559:

Line 4564: UPDATE msc_hz_ui_lines

4560: end if;
4561:
4562: if myco_agg = ORG_AGG and tpco_AGG = COMPANY_AGG then
4563: -- delete site only where user co id is not the id
4564: UPDATE msc_hz_ui_lines
4565: SET FROM_ORG_CODE = null
4566: WHERE FROM_COMPANY_NAME <> v_user_company
4567: AND query_id = arg_query_id ;
4568:

Line 4569: UPDATE msc_hz_ui_lines

4565: SET FROM_ORG_CODE = null
4566: WHERE FROM_COMPANY_NAME <> v_user_company
4567: AND query_id = arg_query_id ;
4568:
4569: UPDATE msc_hz_ui_lines
4570: SET SUPPLIER_ORG_CODE = null
4571: WHERE CUSTOMER_NAME = v_user_company -- user is the customer
4572: AND query_id = arg_query_id ;
4573:

Line 4574: UPDATE msc_hz_ui_lines

4570: SET SUPPLIER_ORG_CODE = null
4571: WHERE CUSTOMER_NAME = v_user_company -- user is the customer
4572: AND query_id = arg_query_id ;
4573:
4574: UPDATE msc_hz_ui_lines
4575: SET CUSTOMER_ORG_CODE = null
4576: WHERE SUPPLIER_NAME = v_user_company -- user is the customer
4577: AND query_id = arg_query_id ;
4578:

Line 4580: UPDATE msc_hz_ui_lines

4576: WHERE SUPPLIER_NAME = v_user_company -- user is the customer
4577: AND query_id = arg_query_id ;
4578:
4579: -- third party
4580: UPDATE msc_hz_ui_lines
4581: SET FROM_ORG_CODE = null,SUPPLIER_ORG_CODE = NULL,
4582: CUSTOMER_ORG_CODE = NULL
4583: WHERE SUPPLIER_NAME <> v_user_company and CUSTOMER_NAME <> v_user_company ;
4584:

Line 4590: UPDATE msc_hz_ui_lines

4586:
4587: if tpco_agg = ALL_AGG then
4588:
4589: -- third party - remove site for all
4590: UPDATE msc_hz_ui_lines
4591: SET FROM_ORG_CODE = null,SUPPLIER_ORG_CODE = NULL,
4592: CUSTOMER_ORG_CODE = NULL
4593: WHERE SUPPLIER_NAME <> v_user_company
4594: AND CUSTOMER_NAME <> v_user_company

Line 4598: UPDATE msc_hz_ui_lines

4594: AND CUSTOMER_NAME <> v_user_company
4595: AND query_id = arg_query_id ;
4596:
4597: -- if doc owner is not user then set it to null for ALL agg.
4598: UPDATE msc_hz_ui_lines
4599: SET FROM_COMPANY_NAME = null, FROM_ORG_CODE = null
4600: WHERE FROM_COMPANY_NAME <> v_user_company
4601: AND (SUPPLIER_NAME = v_user_company OR CUSTOMER_NAME = v_user_company )
4602: AND query_id = arg_query_id ;

Line 4604: UPDATE msc_hz_ui_lines

4600: WHERE FROM_COMPANY_NAME <> v_user_company
4601: AND (SUPPLIER_NAME = v_user_company OR CUSTOMER_NAME = v_user_company )
4602: AND query_id = arg_query_id ;
4603:
4604: UPDATE msc_hz_ui_lines
4605: SET customer_name = FND_MESSAGE.GET_STRING('MSC','MSC_X_HZ_TP_ALL'),
4606: customer_org_code = NULL
4607: --,customer_site_id = NULL
4608: WHERE SUPPLIER_NAME = v_user_company -- user is supplier

Line 4611: UPDATE msc_hz_ui_lines

4607: --,customer_site_id = NULL
4608: WHERE SUPPLIER_NAME = v_user_company -- user is supplier
4609: AND query_id = arg_query_id ;
4610:
4611: UPDATE msc_hz_ui_lines
4612: SET SUPPLIER_NAME = FND_MESSAGE.GET_STRING('MSC','MSC_X_HZ_TP_ALL'),
4613: SUPPLIER_ORG_CODE = NULL
4614: WHERE CUSTOMER_NAME = v_user_company -- user is customer
4615: AND query_id = arg_query_id ;

Line 4619: UPDATE msc_hz_ui_lines

4615: AND query_id = arg_query_id ;
4616:
4617: if myco_agg = COMPANY_AGG then
4618:
4619: UPDATE msc_hz_ui_lines
4620: SET supplier_org_code = null
4621: WHERE SUPPLIER_NAME = v_user_company -- user is supplier
4622: AND query_id = arg_query_id ;
4623:

Line 4624: UPDATE msc_hz_ui_lines

4620: SET supplier_org_code = null
4621: WHERE SUPPLIER_NAME = v_user_company -- user is supplier
4622: AND query_id = arg_query_id ;
4623:
4624: UPDATE msc_hz_ui_lines
4625: SET customer_org_code = null
4626: WHERE CUSTOMER_NAME = v_user_company -- user is customer
4627: AND query_id = arg_query_id ;
4628:

Line 4629: UPDATE msc_hz_ui_lines

4625: SET customer_org_code = null
4626: WHERE CUSTOMER_NAME = v_user_company -- user is customer
4627: AND query_id = arg_query_id ;
4628:
4629: UPDATE msc_hz_ui_lines
4630: SET FROM_ORG_CODE = null
4631: WHERE FROM_COMPANY_NAME <> v_user_company
4632: AND query_id = arg_query_id ;
4633:

Line 4696: FROM msc_hz_ui_lines

4692:
4693:
4694: SELECT count(*)
4695: INTO arg_num_rowset
4696: FROM msc_hz_ui_lines
4697: WHERE query_id = arg_query_id
4698: AND order_type_desc <> fnd_message.get_string('MSC','MSC_X_HZ_RUN_DEMAND')
4699: AND order_type_desc <> fnd_message.get_string('MSC','MSC_X_HZ_RUN_SUPPLY')
4700: ;

Line 4732: FROM msc_hz_ui_lines

4728:
4729:
4730: SELECT count(*)
4731: INTO arg_num_rowset
4732: FROM msc_hz_ui_lines
4733: WHERE query_id = arg_query_id
4734: AND order_type_desc <> fnd_message.get_string('MSC','MSC_X_HZ_RUN_DEMAND')
4735: AND order_type_desc <> fnd_message.get_string('MSC','MSC_X_HZ_RUN_SUPPLY')
4736: ;

Line 4755: FROM msc_hz_ui_lines

4751:
4752:
4753: SELECT count(*)
4754: INTO arg_num_rowset
4755: FROM msc_hz_ui_lines
4756: WHERE query_id = arg_query_id
4757: AND order_type_desc <> fnd_message.get_string('MSC','MSC_X_HZ_RUN_DEMAND')
4758: AND order_type_desc <> fnd_message.get_string('MSC','MSC_X_HZ_RUN_SUPPLY')
4759: ;

Line 4779: FROM msc_hz_ui_lines

4775:
4776: -- SELECT count(distinct relation_group||item_name)
4777: SELECT count(*)
4778: INTO arg_num_rowset
4779: FROM msc_hz_ui_lines
4780: WHERE query_id = arg_query_id
4781: AND order_type_desc <> fnd_message.get_string('MSC','MSC_X_HZ_RUN_DEMAND')
4782: AND order_type_desc <> fnd_message.get_string('MSC','MSC_X_HZ_RUN_SUPPLY')
4783: ;