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: if(var_item_id.count > 0) then

Line 3238: UPDATE msc_hz_ui_lines

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

Line 3274: INSERT INTO msc_hz_ui_lines

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

Line 3331: UPDATE msc_hz_ui_lines

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

Line 3378: DELETE FROM msc_hz_ui_lines

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

Line 3409: FROM msc_hz_ui_lines

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

Line 3441: INSERT INTO msc_hz_ui_lines

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

Line 3788: FROM msc_hz_ui_lines

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

Line 3813: INSERT INTO msc_hz_ui_lines

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

Line 3897: INSERT INTO msc_hz_ui_lines

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

Line 4340: INSERT INTO msc_hz_ui_lines

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

Line 4396: FROM msc_hz_ui_lines

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

Line 4413: FROM msc_hz_ui_lines

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

Line 4463: UPDATE msc_hz_ui_lines

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

Line 4489: FROM msc_hz_ui_lines

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

Line 4519: FROM msc_hz_ui_lines

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

Line 4538: UPDATE msc_hz_ui_lines

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

Line 4546: UPDATE msc_hz_ui_lines

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

Line 4551: UPDATE msc_hz_ui_lines

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

Line 4556: UPDATE msc_hz_ui_lines

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

Line 4565: UPDATE msc_hz_ui_lines

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

Line 4570: UPDATE msc_hz_ui_lines

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

Line 4575: UPDATE msc_hz_ui_lines

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

Line 4581: UPDATE msc_hz_ui_lines

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

Line 4591: UPDATE msc_hz_ui_lines

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

Line 4599: UPDATE msc_hz_ui_lines

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

Line 4605: UPDATE msc_hz_ui_lines

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

Line 4612: UPDATE msc_hz_ui_lines

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

Line 4620: UPDATE msc_hz_ui_lines

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

Line 4625: UPDATE msc_hz_ui_lines

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

Line 4630: UPDATE msc_hz_ui_lines

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

Line 4697: FROM msc_hz_ui_lines

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

Line 4733: FROM msc_hz_ui_lines

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

Line 4756: FROM msc_hz_ui_lines

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

Line 4780: FROM msc_hz_ui_lines

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