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_GANTT_UTILS dependencies on MSC_GET_NAME

Line 176: msc_get_name.alternate_rtg(mrr.plan_id, mrr.sr_instance_id, mrr.routing_sequence_id) alt_rtg,

172: mrr.sr_instance_id, mrr.resource_id, mrr.setup_id)), null) setup_type,
173: mtp.organization_code org_code,
174: ms.new_order_quantity qty,
175: mrr.batch_number,
176: msc_get_name.alternate_rtg(mrr.plan_id, mrr.sr_instance_id, mrr.routing_sequence_id) alt_rtg,
177: mrr.assigned_units,
178: msc_get_name.lookup_meaning('MRP_ORDER_TYPE', ms.order_type) order_type,
179: mro.operation_description op_sdesc,
180: mrr.operation_seq_num,

Line 178: msc_get_name.lookup_meaning('MRP_ORDER_TYPE', ms.order_type) order_type,

174: ms.new_order_quantity qty,
175: mrr.batch_number,
176: msc_get_name.alternate_rtg(mrr.plan_id, mrr.sr_instance_id, mrr.routing_sequence_id) alt_rtg,
177: mrr.assigned_units,
178: msc_get_name.lookup_meaning('MRP_ORDER_TYPE', ms.order_type) order_type,
179: mro.operation_description op_sdesc,
180: mrr.operation_seq_num,
181: mrr.resource_seq_num,
182: ms.requested_completion_date req_comp_date,

Line 183: msc_get_name.supply_order_number(ms.order_type, ms.order_number, ms.plan_id,

179: mro.operation_description op_sdesc,
180: mrr.operation_seq_num,
181: mrr.resource_seq_num,
182: ms.requested_completion_date req_comp_date,
183: msc_get_name.supply_order_number(ms.order_type, ms.order_number, ms.plan_id,
184: ms.sr_instance_id, ms.transaction_id, ms.disposition_id) order_number,
185: mdr.department_code,
186: mdr.resource_code
187: from msc_resource_requirements mrr,

Line 1420: 14, decode(substr(msc_get_name.get_order_number(p_inst_id, p_plan_id,

1416: /*cursor c_order_number is
1417: select decode(p_order_type,
1418: 5, decode(p_order_number, null, to_char(p_trx_id),
1419: p_order_number|| null_space ||to_char(p_trx_id)),
1420: 14, decode(substr(msc_get_name.get_order_number(p_inst_id, p_plan_id,
1421: p_disposition_id, 1),1,240), null, to_char(p_disposition_id),
1422: substr(msc_get_name.get_order_number(p_inst_id, p_plan_id,
1423: p_disposition_id, 1),1,240)
1424: || null_space || to_char(p_disposition_id)),

Line 1422: substr(msc_get_name.get_order_number(p_inst_id, p_plan_id,

1418: 5, decode(p_order_number, null, to_char(p_trx_id),
1419: p_order_number|| null_space ||to_char(p_trx_id)),
1420: 14, decode(substr(msc_get_name.get_order_number(p_inst_id, p_plan_id,
1421: p_disposition_id, 1),1,240), null, to_char(p_disposition_id),
1422: substr(msc_get_name.get_order_number(p_inst_id, p_plan_id,
1423: p_disposition_id, 1),1,240)
1424: || null_space || to_char(p_disposition_id)),
1425: 17, decode(substr(msc_get_name.get_order_number(p_inst_id, p_plan_id,
1426: p_disposition_id, 1),1,240), null, to_char(p_disposition_id),

Line 1425: 17, decode(substr(msc_get_name.get_order_number(p_inst_id, p_plan_id,

1421: p_disposition_id, 1),1,240), null, to_char(p_disposition_id),
1422: substr(msc_get_name.get_order_number(p_inst_id, p_plan_id,
1423: p_disposition_id, 1),1,240)
1424: || null_space || to_char(p_disposition_id)),
1425: 17, decode(substr(msc_get_name.get_order_number(p_inst_id, p_plan_id,
1426: p_disposition_id, 1),1,240), null, to_char(p_disposition_id),
1427: substr(msc_get_name.get_order_number(p_inst_id, p_plan_id,
1428: p_disposition_id, 1),1,240) || null_space || to_char(p_disposition_id)),
1429: 51,to_char(p_trx_id),

Line 1427: substr(msc_get_name.get_order_number(p_inst_id, p_plan_id,

1423: p_disposition_id, 1),1,240)
1424: || null_space || to_char(p_disposition_id)),
1425: 17, decode(substr(msc_get_name.get_order_number(p_inst_id, p_plan_id,
1426: p_disposition_id, 1),1,240), null, to_char(p_disposition_id),
1427: substr(msc_get_name.get_order_number(p_inst_id, p_plan_id,
1428: p_disposition_id, 1),1,240) || null_space || to_char(p_disposition_id)),
1429: 51,to_char(p_trx_id),
1430: 52,to_char(p_trx_id),
1431: 15,to_char(p_trx_id),

Line 1452: l_temp := Substr(msc_get_name.get_order_number

1448: Else
1449: l_order_number := p_order_number|| null_space ||To_Char(p_trx_id);
1450: End If;
1451: Elsif p_order_type In (14, 17) Then
1452: l_temp := Substr(msc_get_name.get_order_number
1453: (p_inst_id, p_plan_id,
1454: p_disposition_id, 1),1,240);
1455: If l_temp Is Null Then
1456: l_order_number := To_Char(p_disposition_id);

Line 1486: select msc_get_name.item_name(mdri.equipment_item_id, null, null, null)

1482: and mtp.sr_tp_id = mdr.organization_id
1483: and mtp.sr_instance_id = mdr.sr_instance_id;
1484:
1485: cursor inst_name is
1486: select msc_get_name.item_name(mdri.equipment_item_id, null, null, null)
1487: ||decode(mdri.serial_number, null, null_space, COLON_SEPARATOR || mdri.serial_number)
1488: from msc_dept_res_instances mdri,
1489: msc_department_resources mdr,
1490: msc_trading_partners mtp

Line 3240: msc_get_name.supply_order_number(ms.order_type, ms.order_number, ms.plan_id,

3236: mrr.uepcd,
3237: mrr.eacd,
3238: msc_gantt_utils.getResActResNodeLabel(mrr.plan_id, mrr.sr_instance_id, mrr.transaction_id) bar_text,
3239: ms.inventory_item_id,
3240: msc_get_name.supply_order_number(ms.order_type, ms.order_number, ms.plan_id,
3241: ms.sr_instance_id, ms.transaction_id, ms.disposition_id) order_number,
3242: mrr.operation_seq_num,
3243: mrr.resource_seq_num,
3244: mdr.resource_description,

Line 3251: msc_get_name.setup_code(mrr.plan_id, mrr.sr_instance_id, mrr.resource_id,

3247: decode(mrr.resource_hours, 0, to_number(null),
3248: nvl(mrr.cummulative_quantity,ms.new_order_quantity)) schedule_qty,
3249: decode(mrr.from_setup_id,
3250: to_number(null), null,
3251: msc_get_name.setup_code(mrr.plan_id, mrr.sr_instance_id, mrr.resource_id,
3252: mrr.organization_id, mrr.from_setup_id)) from_setup_code,
3253: decode(mrr.setup_id,
3254: to_number(null), null,
3255: msc_get_name.setup_code(mrr.plan_id, mrr.sr_instance_id, mrr.resource_id,

Line 3255: msc_get_name.setup_code(mrr.plan_id, mrr.sr_instance_id, mrr.resource_id,

3251: msc_get_name.setup_code(mrr.plan_id, mrr.sr_instance_id, mrr.resource_id,
3252: mrr.organization_id, mrr.from_setup_id)) from_setup_code,
3253: decode(mrr.setup_id,
3254: to_number(null), null,
3255: msc_get_name.setup_code(mrr.plan_id, mrr.sr_instance_id, mrr.resource_id,
3256: mrr.organization_id, mrr.setup_id)) to_setup_code,
3257: decode(mrr.from_setup_id,
3258: to_number(null), null,
3259: msc_gantt_utils.getTansitionValue(mrr.plan_id, mrr.sr_instance_id,

Line 3360: msc_get_name.supply_order_number(ms.order_type, ms.order_number, ms.plan_id,

3356: mrr.uepcd,
3357: mrr.eacd,
3358: msc_gantt_utils.getResActResNodeLabel(mrr.plan_id, mrr.sr_instance_id, mrr.transaction_id) bar_text,
3359: ms.inventory_item_id,
3360: msc_get_name.supply_order_number(ms.order_type, ms.order_number, ms.plan_id,
3361: ms.sr_instance_id, ms.transaction_id, ms.disposition_id) order_number,
3362: mrr.operation_seq_num,
3363: mrr.resource_seq_num,
3364: mdr.resource_description,

Line 3371: msc_get_name.setup_code(mrr.plan_id, mrr.sr_instance_id, mrr.resource_id,

3367: decode(mrr.resource_hours, 0, to_number(null),
3368: nvl(mrr.cummulative_quantity,ms.new_order_quantity)) schedule_qty,
3369: decode(mrr.from_setup_id,
3370: to_number(null), null,
3371: msc_get_name.setup_code(mrr.plan_id, mrr.sr_instance_id, mrr.resource_id,
3372: mrr.organization_id, mrr.from_setup_id)) from_setup_code,
3373: decode(mrr.setup_id,
3374: to_number(null), null,
3375: msc_get_name.setup_code(mrr.plan_id, mrr.sr_instance_id, mrr.resource_id,

Line 3375: msc_get_name.setup_code(mrr.plan_id, mrr.sr_instance_id, mrr.resource_id,

3371: msc_get_name.setup_code(mrr.plan_id, mrr.sr_instance_id, mrr.resource_id,
3372: mrr.organization_id, mrr.from_setup_id)) from_setup_code,
3373: decode(mrr.setup_id,
3374: to_number(null), null,
3375: msc_get_name.setup_code(mrr.plan_id, mrr.sr_instance_id, mrr.resource_id,
3376: mrr.organization_id, mrr.setup_id)) to_setup_code,
3377: decode(mrr.from_setup_id,
3378: to_number(null), null,
3379: msc_gantt_utils.getTansitionValue(mrr.plan_id, mrr.sr_instance_id,

Line 3471: msc_get_name.org_code(mrr.organization_id, mrr.sr_instance_id),

3467: to_number(null), null_space,
3468: msc_gantt_utils.getSetupCode(mrr.plan_id,
3469: mrr.sr_instance_id, mrr.resource_id, mrr.setup_id)),
3470: null_space),
3471: msc_get_name.org_code(mrr.organization_id, mrr.sr_instance_id),
3472: to_char(sum(ms.new_order_quantity)),
3473: to_char(mrr.batch_number),
3474: to_char(sum(mrr.capacity_consumed_ratio))) bar_text
3475: from msc_resource_requirements mrr,

Line 3526: msc_get_name.org_code(mrr.organization_id, mrr.sr_instance_id),

3522: group by mgq.row_index,
3523: mrr.plan_id,
3524: mrr.sr_instance_id,
3525: mrr.organization_id,
3526: msc_get_name.org_code(mrr.organization_id, mrr.sr_instance_id),
3527: mrr.resource_id,
3528: mrr.batch_number,
3529: msc_gantt_utils.getResReqStartDate(nvl(mrr.firm_flag,0), mrr.start_date, mrr.end_date,
3530: mrr.firm_start_date, mrr.firm_end_date, mrr.status, mrr.applied),

Line 3553: msc_get_name.org_code(mrr.organization_id, mrr.sr_instance_id),

3549: to_number(null), null_space,
3550: msc_gantt_utils.getSetupCode(mrr.plan_id,
3551: mrr.sr_instance_id, mrr.resource_id, mrr.setup_id)),
3552: null_space),
3553: msc_get_name.org_code(mrr.organization_id, mrr.sr_instance_id),
3554: to_char(sum(ms.new_order_quantity)),
3555: to_char(mrir.batch_number),
3556: to_char(sum(mrir.capacity_consumed_ratio))) bar_text
3557: from msc_resource_instance_reqs mrir,

Line 3608: msc_get_name.org_code(mrr.organization_id, mrr.sr_instance_id),

3604: group by mgq.row_index,
3605: mrr.plan_id,
3606: mrr.sr_instance_id,
3607: mrr.organization_id,
3608: msc_get_name.org_code(mrr.organization_id, mrr.sr_instance_id),
3609: mrr.resource_id,
3610: mrir.batch_number,
3611: msc_gantt_utils.getResReqStartDate(nvl(mrr.firm_flag,0), mrir.start_date, mrir.end_date,
3612: mrr.firm_start_date, mrr.firm_end_date, mrr.status, mrr.applied),

Line 4827: msc_get_name.execute_dsql(res_where_stat);

4823: ||' where plan_id = '||p_plan_id
4824: --||' and res_instance_id is null '
4825: ||' and 1=1 '||p_where;
4826:
4827: msc_get_name.execute_dsql(res_where_stat);
4828:
4829: res_where_stat := 'select number1, number2, number3, number4, number5, char1 '
4830: ||' from msc_form_query mfq, '
4831: ||' msc_among_values mav '

Line 7144: msc_get_name.resource_code(mor.resource_id, mrr.department_id,

7140: p_from_form number default null) is
7141:
7142: cursor c_alt_res_res (p_plan number, p_inst number, p_trx number)is
7143: select distinct mor.alternate_number || COLON_SEPARATOR ||
7144: msc_get_name.resource_code(mor.resource_id, mrr.department_id,
7145: mrr.organization_id, mrr.plan_id, mrr.sr_instance_id),
7146: mor.resource_id,
7147: mbp_null_value res_instance_id,
7148: mbp_null_value_char serial_number,

Line 7164: msc_get_name.resource_code(mjor.resource_id, mrr.department_id,

7160: and mor.alternate_number <> mrr.alternate_num
7161: and mor.principal_flag <> 2
7162: union all --5478582 bugfix
7163: select distinct mjor.alternate_num || COLON_SEPARATOR ||
7164: msc_get_name.resource_code(mjor.resource_id, mrr.department_id,
7165: mrr.organization_id, mrr.plan_id, mrr.sr_instance_id),
7166: mjor.resource_id,
7167: mbp_null_value res_instance_id,
7168: mbp_null_value_char serial_number,

Line 7243: || COLON_SEPARATOR ||msc_get_name.resource_code(mor.resource_id, mrr.department_id,

7239:
7240:
7241: cursor c_alt_inst_res (p_plan number, p_inst number, p_trx number)is
7242: select distinct mor.alternate_number
7243: || COLON_SEPARATOR ||msc_get_name.resource_code(mor.resource_id, mrr.department_id,
7244: mrr.organization_id, mrr.plan_id, mrr.sr_instance_id),
7245: mor.resource_id,
7246: mbp_null_value res_instance_id,
7247: mbp_null_value_char serial_number,

Line 7263: || COLON_SEPARATOR ||msc_get_name.resource_code(mjor.resource_id, mrr.department_id,

7259: and mor.alternate_number <> mrr.alternate_num
7260: and mor.principal_flag <> 2
7261: union all --5478582 bugfix
7262: select distinct mjor.alternate_num
7263: || COLON_SEPARATOR ||msc_get_name.resource_code(mjor.resource_id, mrr.department_id,
7264: mrr.organization_id, mrr.plan_id, mrr.sr_instance_id),
7265: mjor.resource_id,
7266: mbp_null_value res_instance_id,
7267: mbp_null_value_char serial_number,

Line 7613: select msc_get_name.resource_code(mor.resource_id, mrr.department_id,

7609: p_name OUT NOCOPY varchar2, p_id OUT NOCOPY varchar2,
7610: p_node_type number default null) IS
7611:
7612: cursor c_simu_res_res(p_plan_id number, p_inst_id number, p_trx_id number ) is
7613: select msc_get_name.resource_code(mor.resource_id, mrr.department_id,
7614: mrr.organization_id, mrr.plan_id, mrr.sr_instance_id) resource_code,
7615: mor.resource_id resource_id,
7616: mbp_null_value res_instance_id,
7617: mbp_null_value_char serial_number

Line 7656: select mor.alternate_number ||':'||msc_get_name.resource_code(mor.resource_id, mrr.department_id,

7652: and mor.sr_instance_id = mdri.sr_instance_id
7653: and mor.resource_id = mdri.resource_id;
7654:
7655: cursor c_simu_inst_res (p_plan number, p_inst number, p_trx number)is
7656: select mor.alternate_number ||':'||msc_get_name.resource_code(mor.resource_id, mrr.department_id,
7657: mrr.organization_id, mrr.plan_id, mrr.sr_instance_id) resource_code,
7658: mor.resource_id,
7659: mbp_null_value res_instance_id,
7660: mbp_null_value_char serial_number

Line 8160: nvl(msc_get_name.project(ms.project_id,ms.organization_id,

8156: nvl(to_char(ms.firm_date,format_mask), null_space) firm_date,
8157: to_char(ms.new_schedule_date,format_mask) sugg_due_date,
8158: nvl(to_char(ms.need_by_date,format_mask), null_space) needby,
8159: nvl(ms.unit_number,null_space) unit_number,
8160: nvl(msc_get_name.project(ms.project_id,ms.organization_id,
8161: ms.plan_id, ms.sr_instance_id), null_space) project,
8162: nvl(msc_get_name.task(ms.task_id, ms.project_id, ms.organization_id,
8163: ms.plan_id, ms.sr_instance_id),null_space) task,
8164: msc_get_name.org_code(ms.organization_id, ms.sr_instance_id) org,

Line 8162: nvl(msc_get_name.task(ms.task_id, ms.project_id, ms.organization_id,

8158: nvl(to_char(ms.need_by_date,format_mask), null_space) needby,
8159: nvl(ms.unit_number,null_space) unit_number,
8160: nvl(msc_get_name.project(ms.project_id,ms.organization_id,
8161: ms.plan_id, ms.sr_instance_id), null_space) project,
8162: nvl(msc_get_name.task(ms.task_id, ms.project_id, ms.organization_id,
8163: ms.plan_id, ms.sr_instance_id),null_space) task,
8164: msc_get_name.org_code(ms.organization_id, ms.sr_instance_id) org,
8165: decode(ms.order_type,
8166: 5, decode(ms.order_number,

Line 8164: msc_get_name.org_code(ms.organization_id, ms.sr_instance_id) org,

8160: nvl(msc_get_name.project(ms.project_id,ms.organization_id,
8161: ms.plan_id, ms.sr_instance_id), null_space) project,
8162: nvl(msc_get_name.task(ms.task_id, ms.project_id, ms.organization_id,
8163: ms.plan_id, ms.sr_instance_id),null_space) task,
8164: msc_get_name.org_code(ms.organization_id, ms.sr_instance_id) org,
8165: decode(ms.order_type,
8166: 5, decode(ms.order_number,
8167: null, to_char(ms.transaction_id),
8168: replace(ms.order_number,'~','^')||' '||to_char(ms.transaction_id)),

Line 8175: nvl(msc_get_name.supply_type(ms.transaction_id, p_plan_id), null_space) supply_type,

8171: nvl(ms.alternate_bom_designator, null_space) alternate_bom_designator,
8172: nvl(ms.alternate_routing_designator, null_space) alternate_routing_designator,
8173: ms.organization_id org_id,
8174: nvl(to_char(msi.planning_time_fence_date, format_mask),null_space) time_fence,
8175: nvl(msc_get_name.supply_type(ms.transaction_id, p_plan_id), null_space) supply_type,
8176: decode(msc_gantt_utils.getSupplyType(ms.order_type, msi.planning_make_buy_code,
8177: ms.organization_id, ms.source_organization_id),
8178: BUY_SUPPLY, l_buy_text,
8179: TRANSFER_SUPPLY, l_transfer_text,

Line 8182: nvl(msc_get_name.supplier(nvl(ms.source_supplier_id, ms.supplier_id)), null_space) supplier,

8178: BUY_SUPPLY, l_buy_text,
8179: TRANSFER_SUPPLY, l_transfer_text,
8180: MAKE_SUPPLY, l_make_text) item_type,
8181: msi.description,
8182: nvl(msc_get_name.supplier(nvl(ms.source_supplier_id, ms.supplier_id)), null_space) supplier,
8183: nvl(msc_get_name.org_code(ms.source_organization_id, ms.source_sr_instance_id),null_space) source_org,
8184: nvl(ms.ship_method, null_space) ship_method,
8185: msc_get_name.lookup_meaning('SYS_YES_NO', decode(ms.supply_is_shared,1,1,2)) share_supply,
8186: nvl(to_char(ms.EARLIEST_START_DATE,format_mask),null_space) EPSD,

Line 8183: nvl(msc_get_name.org_code(ms.source_organization_id, ms.source_sr_instance_id),null_space) source_org,

8179: TRANSFER_SUPPLY, l_transfer_text,
8180: MAKE_SUPPLY, l_make_text) item_type,
8181: msi.description,
8182: nvl(msc_get_name.supplier(nvl(ms.source_supplier_id, ms.supplier_id)), null_space) supplier,
8183: nvl(msc_get_name.org_code(ms.source_organization_id, ms.source_sr_instance_id),null_space) source_org,
8184: nvl(ms.ship_method, null_space) ship_method,
8185: msc_get_name.lookup_meaning('SYS_YES_NO', decode(ms.supply_is_shared,1,1,2)) share_supply,
8186: nvl(to_char(ms.EARLIEST_START_DATE,format_mask),null_space) EPSD,
8187: nvl(to_char(ms.EARLIEST_COMPLETION_DATE,format_mask),null_space) EPCD,

Line 8185: msc_get_name.lookup_meaning('SYS_YES_NO', decode(ms.supply_is_shared,1,1,2)) share_supply,

8181: msi.description,
8182: nvl(msc_get_name.supplier(nvl(ms.source_supplier_id, ms.supplier_id)), null_space) supplier,
8183: nvl(msc_get_name.org_code(ms.source_organization_id, ms.source_sr_instance_id),null_space) source_org,
8184: nvl(ms.ship_method, null_space) ship_method,
8185: msc_get_name.lookup_meaning('SYS_YES_NO', decode(ms.supply_is_shared,1,1,2)) share_supply,
8186: nvl(to_char(ms.EARLIEST_START_DATE,format_mask),null_space) EPSD,
8187: nvl(to_char(ms.EARLIEST_COMPLETION_DATE,format_mask),null_space) EPCD,
8188: nvl(to_char(ms.UEPSD,format_mask),null_space) UEPSD,
8189: nvl(to_char(ms.UEPCD,format_mask),null_space) UEPCD,

Line 8203: select msc_get_name.item_name(mrr.assembly_item_id,null,null,null) item,

8199: and msi.sr_instance_id = ms.sr_instance_id
8200: and msi.inventory_item_id = ms.inventory_item_id;
8201:
8202: cursor res_cur is
8203: select msc_get_name.item_name(mrr.assembly_item_id,null,null,null) item,
8204: nvl(mrr.operation_seq_num,0) op_seq,
8205: msc_get_name.org_code(mrr.organization_id, mrr.sr_instance_id) org,
8206: msc_get_name.department_code(decode(mrr.resource_id, -1, 1,2),
8207: mrr.department_id, mrr.organization_id, mrr.plan_id, mrr.sr_instance_id) dept_code,

Line 8205: msc_get_name.org_code(mrr.organization_id, mrr.sr_instance_id) org,

8201:
8202: cursor res_cur is
8203: select msc_get_name.item_name(mrr.assembly_item_id,null,null,null) item,
8204: nvl(mrr.operation_seq_num,0) op_seq,
8205: msc_get_name.org_code(mrr.organization_id, mrr.sr_instance_id) org,
8206: msc_get_name.department_code(decode(mrr.resource_id, -1, 1,2),
8207: mrr.department_id, mrr.organization_id, mrr.plan_id, mrr.sr_instance_id) dept_code,
8208: nvl(msc_get_name.job_name(mrr.supply_id, p_plan_id), to_char(mrr.supply_id)) job_name,
8209: nvl(mrr.assigned_units,0) assigned_units,

Line 8206: msc_get_name.department_code(decode(mrr.resource_id, -1, 1,2),

8202: cursor res_cur is
8203: select msc_get_name.item_name(mrr.assembly_item_id,null,null,null) item,
8204: nvl(mrr.operation_seq_num,0) op_seq,
8205: msc_get_name.org_code(mrr.organization_id, mrr.sr_instance_id) org,
8206: msc_get_name.department_code(decode(mrr.resource_id, -1, 1,2),
8207: mrr.department_id, mrr.organization_id, mrr.plan_id, mrr.sr_instance_id) dept_code,
8208: nvl(msc_get_name.job_name(mrr.supply_id, p_plan_id), to_char(mrr.supply_id)) job_name,
8209: nvl(mrr.assigned_units,0) assigned_units,
8210: msc_get_name.lookup_meaning('RESOURCE_FIRM_TYPE', nvl(mrr.firm_flag,0)) firm_flag,

Line 8208: nvl(msc_get_name.job_name(mrr.supply_id, p_plan_id), to_char(mrr.supply_id)) job_name,

8204: nvl(mrr.operation_seq_num,0) op_seq,
8205: msc_get_name.org_code(mrr.organization_id, mrr.sr_instance_id) org,
8206: msc_get_name.department_code(decode(mrr.resource_id, -1, 1,2),
8207: mrr.department_id, mrr.organization_id, mrr.plan_id, mrr.sr_instance_id) dept_code,
8208: nvl(msc_get_name.job_name(mrr.supply_id, p_plan_id), to_char(mrr.supply_id)) job_name,
8209: nvl(mrr.assigned_units,0) assigned_units,
8210: msc_get_name.lookup_meaning('RESOURCE_FIRM_TYPE', nvl(mrr.firm_flag,0)) firm_flag,
8211: nvl(mrr.alternate_num,0) alternate_num,
8212: nvl(mrr.resource_seq_num,0) res_seq_num,

Line 8210: msc_get_name.lookup_meaning('RESOURCE_FIRM_TYPE', nvl(mrr.firm_flag,0)) firm_flag,

8206: msc_get_name.department_code(decode(mrr.resource_id, -1, 1,2),
8207: mrr.department_id, mrr.organization_id, mrr.plan_id, mrr.sr_instance_id) dept_code,
8208: nvl(msc_get_name.job_name(mrr.supply_id, p_plan_id), to_char(mrr.supply_id)) job_name,
8209: nvl(mrr.assigned_units,0) assigned_units,
8210: msc_get_name.lookup_meaning('RESOURCE_FIRM_TYPE', nvl(mrr.firm_flag,0)) firm_flag,
8211: nvl(mrr.alternate_num,0) alternate_num,
8212: nvl(mrr.resource_seq_num,0) res_seq_num,
8213: nvl(msc_get_name.resource_code(mrr.resource_id, mrr.department_id,
8214: mrr.organization_id, mrr.plan_id, mrr.sr_instance_id), null_space) res_code,

Line 8213: nvl(msc_get_name.resource_code(mrr.resource_id, mrr.department_id,

8209: nvl(mrr.assigned_units,0) assigned_units,
8210: msc_get_name.lookup_meaning('RESOURCE_FIRM_TYPE', nvl(mrr.firm_flag,0)) firm_flag,
8211: nvl(mrr.alternate_num,0) alternate_num,
8212: nvl(mrr.resource_seq_num,0) res_seq_num,
8213: nvl(msc_get_name.resource_code(mrr.resource_id, mrr.department_id,
8214: mrr.organization_id, mrr.plan_id, mrr.sr_instance_id), null_space) res_code,
8215: nvl(mrr.resource_hours,0) resource_hours,
8216: ms.organization_id org_id,
8217: ms.transaction_id trans_id,

Line 8224: msc_get_name.lookup_meaning('MSC_RES_BASIS_TYPE',mrr.basis_type)),null_space) basis_type,

8220: nvl(to_char(mrr.batch_number), null_space) batch_number,
8221: nvl(mdr.unit_of_measure,null_space) uom,
8222: nvl(decode(mrr.basis_type,
8223: null, null_space,
8224: msc_get_name.lookup_meaning('MSC_RES_BASIS_TYPE',mrr.basis_type)),null_space) basis_type,
8225: nvl(decode(mrr.schedule_flag,
8226: null, null_space,
8227: msc_get_name.lookup_meaning('BOM_RESOURCE_SCHEDULE_TYPE',mrr.schedule_flag)),null_space) schedule_flag,
8228: nvl(to_char(mrr.EARLIEST_START_DATE,format_mask),null_space) EPSD,

Line 8227: msc_get_name.lookup_meaning('BOM_RESOURCE_SCHEDULE_TYPE',mrr.schedule_flag)),null_space) schedule_flag,

8223: null, null_space,
8224: msc_get_name.lookup_meaning('MSC_RES_BASIS_TYPE',mrr.basis_type)),null_space) basis_type,
8225: nvl(decode(mrr.schedule_flag,
8226: null, null_space,
8227: msc_get_name.lookup_meaning('BOM_RESOURCE_SCHEDULE_TYPE',mrr.schedule_flag)),null_space) schedule_flag,
8228: nvl(to_char(mrr.EARLIEST_START_DATE,format_mask),null_space) EPSD,
8229: nvl(to_char(mrr.EARLIEST_COMPLETION_DATE,format_mask),null_space) EPCD,
8230: nvl(to_char(mrr.UEPSD,format_mask),null_space) UEPSD,
8231: nvl(to_char(mrr.UEPCD,format_mask),null_space) UEPCD,

Line 8342: select msc_get_name.item_name(ms.inventory_item_id,null,null,null) item,

8338: p_transaction_id number, p_instance_id number, p_end_demand_id number,
8339: v_job OUT NOCOPY varchar2, v_demand OUT NOCOPY varchar2) IS
8340:
8341: cursor property is
8342: select msc_get_name.item_name(ms.inventory_item_id,null,null,null) item,
8343: mrr.operation_seq_num,
8344: ms.new_order_quantity qty,
8345: nvl(to_char(ms.firm_date,format_mask),null_space) firm_date,
8346: to_char(ms.new_schedule_date,format_mask) sugg_due_date,

Line 8349: nvl(msc_get_name.project(ms.project_id,ms.organization_id,

8345: nvl(to_char(ms.firm_date,format_mask),null_space) firm_date,
8346: to_char(ms.new_schedule_date,format_mask) sugg_due_date,
8347: nvl(to_char(ms.need_by_date,format_mask),null_space) needby,
8348: nvl(ms.unit_number,null_space) unit_number,
8349: nvl(msc_get_name.project(ms.project_id,ms.organization_id,
8350: ms.plan_id, ms.sr_instance_id), null_space) project,
8351: nvl(msc_get_name.task(ms.task_id, ms.project_id, ms.organization_id,
8352: ms.plan_id, ms.sr_instance_id),null_space) task,
8353: ms.transaction_id,

Line 8351: nvl(msc_get_name.task(ms.task_id, ms.project_id, ms.organization_id,

8347: nvl(to_char(ms.need_by_date,format_mask),null_space) needby,
8348: nvl(ms.unit_number,null_space) unit_number,
8349: nvl(msc_get_name.project(ms.project_id,ms.organization_id,
8350: ms.plan_id, ms.sr_instance_id), null_space) project,
8351: nvl(msc_get_name.task(ms.task_id, ms.project_id, ms.organization_id,
8352: ms.plan_id, ms.sr_instance_id),null_space) task,
8353: ms.transaction_id,
8354: ms.organization_id,
8355: msc_get_name.org_code(mdr.organization_id, mdr.sr_instance_id) org,

Line 8355: msc_get_name.org_code(mdr.organization_id, mdr.sr_instance_id) org,

8351: nvl(msc_get_name.task(ms.task_id, ms.project_id, ms.organization_id,
8352: ms.plan_id, ms.sr_instance_id),null_space) task,
8353: ms.transaction_id,
8354: ms.organization_id,
8355: msc_get_name.org_code(mdr.organization_id, mdr.sr_instance_id) org,
8356: mdr.department_code,
8357: decode(ms.order_type,
8358: 5, decode(ms.order_number,
8359: null,to_char(ms.transaction_id),

Line 8363: nvl(msc_get_name.lookup_meaning('RESOURCE_FIRM_TYPE',nvl(mrr.firm_flag,NO_FIRM)),

8359: null,to_char(ms.transaction_id),
8360: replace(ms.order_number,'~','^')||' '||to_char(ms.transaction_id)),
8361: nvl(replace(ms.order_number,'~','^'),to_char(ms.transaction_id))) job_name,
8362: mrr.assigned_units,
8363: nvl(msc_get_name.lookup_meaning('RESOURCE_FIRM_TYPE',nvl(mrr.firm_flag,NO_FIRM)),
8364: msc_get_name.lookup_meaning('RESOURCE_FIRM_TYPE',0))
8365: firm_flag,
8366: ms.firm_planned_type,
8367: nvl(mrr.alternate_num,0) alternate_num,

Line 8364: msc_get_name.lookup_meaning('RESOURCE_FIRM_TYPE',0))

8360: replace(ms.order_number,'~','^')||' '||to_char(ms.transaction_id)),
8361: nvl(replace(ms.order_number,'~','^'),to_char(ms.transaction_id))) job_name,
8362: mrr.assigned_units,
8363: nvl(msc_get_name.lookup_meaning('RESOURCE_FIRM_TYPE',nvl(mrr.firm_flag,NO_FIRM)),
8364: msc_get_name.lookup_meaning('RESOURCE_FIRM_TYPE',0))
8365: firm_flag,
8366: ms.firm_planned_type,
8367: nvl(mrr.alternate_num,0) alternate_num,
8368: mrr.resource_seq_num,

Line 8371: nvl(msc_get_name.alternate_bom(pe.plan_id, pe.sr_instance_id,

8367: nvl(mrr.alternate_num,0) alternate_num,
8368: mrr.resource_seq_num,
8369: nvl(mdr.resource_code, null_space) resource_code,
8370: mrr.resource_hours,
8371: nvl(msc_get_name.alternate_bom(pe.plan_id, pe.sr_instance_id,
8372: pe.bill_sequence_id),null_space) alternate_bom_designator,
8373: nvl(msc_get_name.alternate_bom(pe.plan_id, pe.sr_instance_id,
8374: pe.bill_sequence_id),null_space) alternate_routing_designator,
8375: nvl(to_char(msi.planning_time_fence_date, format_mask),null_space) time_fence,

Line 8373: nvl(msc_get_name.alternate_bom(pe.plan_id, pe.sr_instance_id,

8369: nvl(mdr.resource_code, null_space) resource_code,
8370: mrr.resource_hours,
8371: nvl(msc_get_name.alternate_bom(pe.plan_id, pe.sr_instance_id,
8372: pe.bill_sequence_id),null_space) alternate_bom_designator,
8373: nvl(msc_get_name.alternate_bom(pe.plan_id, pe.sr_instance_id,
8374: pe.bill_sequence_id),null_space) alternate_routing_designator,
8375: nvl(to_char(msi.planning_time_fence_date, format_mask),null_space) time_fence,
8376: 0 mtq_time, --getMTQTime(p_transaction_id, p_plan_id, p_instance_id) mtq_time,
8377: nvl(mdr.batchable_flag, 2) batchable,

Line 8382: msc_get_name.lookup_meaning('MSC_RES_BASIS_TYPE',mrr.basis_type)),null_space) basis_type,

8378: nvl(to_char(mrr.batch_number), null_space) batch_number,
8379: nvl(mdr.unit_of_measure,null_space) uom,
8380: nvl(decode(to_char(mrr.basis_type),
8381: null, null_space,
8382: msc_get_name.lookup_meaning('MSC_RES_BASIS_TYPE',mrr.basis_type)),null_space) basis_type,
8383: nvl(decode(to_char(mrr.schedule_flag),
8384: null, null_space,
8385: msc_get_name.lookup_meaning('BOM_RESOURCE_SCHEDULE_TYPE',mrr.schedule_flag)),null_space) schedule_flag,
8386: nvl(to_char(mrr.EARLIEST_START_DATE,format_mask),null_space) EPSD,

Line 8385: msc_get_name.lookup_meaning('BOM_RESOURCE_SCHEDULE_TYPE',mrr.schedule_flag)),null_space) schedule_flag,

8381: null, null_space,
8382: msc_get_name.lookup_meaning('MSC_RES_BASIS_TYPE',mrr.basis_type)),null_space) basis_type,
8383: nvl(decode(to_char(mrr.schedule_flag),
8384: null, null_space,
8385: msc_get_name.lookup_meaning('BOM_RESOURCE_SCHEDULE_TYPE',mrr.schedule_flag)),null_space) schedule_flag,
8386: nvl(to_char(mrr.EARLIEST_START_DATE,format_mask),null_space) EPSD,
8387: nvl(to_char(mrr.EARLIEST_COMPLETION_DATE,format_mask),null_space) EPCD,
8388: nvl(to_char(mrr.UEPSD,format_mask),null_space) UEPSD,
8389: nvl(to_char(mrr.UEPCD,format_mask),null_space) UEPCD,

Line 8491: msc_get_name.lookup_meaning('MRP_FLP_SUPPLY_DEMAND_TYPE', v_demand_id) type,

8487:
8488: cursor other_demand is
8489: select nvl(v_demand_quantity,0) qty,
8490: nvl(to_char(v_demand_date,format_mask), null_space) demand_date,
8491: msc_get_name.lookup_meaning('MRP_FLP_SUPPLY_DEMAND_TYPE', v_demand_id) type,
8492: item_name item
8493: from msc_items
8494: where inventory_item_id = v_item_id;
8495:

Line 8499: msc_get_name.demand_order_number (md.plan_id,md.sr_instance_id,md.demand_id) name,

8495:
8496: cursor demand is
8497: select md.using_requirement_quantity qty,
8498: to_char(md.using_assembly_demand_date, format_mask) demand_date,
8499: msc_get_name.demand_order_number (md.plan_id,md.sr_instance_id,md.demand_id) name,
8500: msc_get_name.lookup_meaning('MRP_DEMAND_ORIGINATION', md.origination_type) type,
8501: msc_get_name.item_name(md.inventory_item_id, null,null,null) item,
8502: nvl(md.demand_priority,0) priority,
8503: nvl(replace(msc_get_name.customer(md.customer_id),'&','*'), null_space) customer,

Line 8500: msc_get_name.lookup_meaning('MRP_DEMAND_ORIGINATION', md.origination_type) type,

8496: cursor demand is
8497: select md.using_requirement_quantity qty,
8498: to_char(md.using_assembly_demand_date, format_mask) demand_date,
8499: msc_get_name.demand_order_number (md.plan_id,md.sr_instance_id,md.demand_id) name,
8500: msc_get_name.lookup_meaning('MRP_DEMAND_ORIGINATION', md.origination_type) type,
8501: msc_get_name.item_name(md.inventory_item_id, null,null,null) item,
8502: nvl(md.demand_priority,0) priority,
8503: nvl(replace(msc_get_name.customer(md.customer_id),'&','*'), null_space) customer,
8504: nvl(replace(msc_get_name.customer_site(md.customer_site_id),'&','*'), null_space) customer_site,

Line 8501: msc_get_name.item_name(md.inventory_item_id, null,null,null) item,

8497: select md.using_requirement_quantity qty,
8498: to_char(md.using_assembly_demand_date, format_mask) demand_date,
8499: msc_get_name.demand_order_number (md.plan_id,md.sr_instance_id,md.demand_id) name,
8500: msc_get_name.lookup_meaning('MRP_DEMAND_ORIGINATION', md.origination_type) type,
8501: msc_get_name.item_name(md.inventory_item_id, null,null,null) item,
8502: nvl(md.demand_priority,0) priority,
8503: nvl(replace(msc_get_name.customer(md.customer_id),'&','*'), null_space) customer,
8504: nvl(replace(msc_get_name.customer_site(md.customer_site_id),'&','*'), null_space) customer_site,
8505: nvl(to_char(md.dmd_satisfied_date,format_mask), null_space) satisfied_date,

Line 8503: nvl(replace(msc_get_name.customer(md.customer_id),'&','*'), null_space) customer,

8499: msc_get_name.demand_order_number (md.plan_id,md.sr_instance_id,md.demand_id) name,
8500: msc_get_name.lookup_meaning('MRP_DEMAND_ORIGINATION', md.origination_type) type,
8501: msc_get_name.item_name(md.inventory_item_id, null,null,null) item,
8502: nvl(md.demand_priority,0) priority,
8503: nvl(replace(msc_get_name.customer(md.customer_id),'&','*'), null_space) customer,
8504: nvl(replace(msc_get_name.customer_site(md.customer_site_id),'&','*'), null_space) customer_site,
8505: nvl(to_char(md.dmd_satisfied_date,format_mask), null_space) satisfied_date,
8506: decode(sign(md.dmd_satisfied_date - md.using_assembly_demand_date),
8507: 1, GREATEST(round(md.dmd_satisfied_date - md.using_assembly_demand_date,2), 0.01), 0) days_late,

Line 8504: nvl(replace(msc_get_name.customer_site(md.customer_site_id),'&','*'), null_space) customer_site,

8500: msc_get_name.lookup_meaning('MRP_DEMAND_ORIGINATION', md.origination_type) type,
8501: msc_get_name.item_name(md.inventory_item_id, null,null,null) item,
8502: nvl(md.demand_priority,0) priority,
8503: nvl(replace(msc_get_name.customer(md.customer_id),'&','*'), null_space) customer,
8504: nvl(replace(msc_get_name.customer_site(md.customer_site_id),'&','*'), null_space) customer_site,
8505: nvl(to_char(md.dmd_satisfied_date,format_mask), null_space) satisfied_date,
8506: decode(sign(md.dmd_satisfied_date - md.using_assembly_demand_date),
8507: 1, GREATEST(round(md.dmd_satisfied_date - md.using_assembly_demand_date,2), 0.01), 0) days_late,
8508: nvl(to_char(md.quantity_by_due_date),null_space) qty_by_due_date,

Line 8509: msc_get_name.org_code(md.organization_id, md.sr_instance_id) org,

8505: nvl(to_char(md.dmd_satisfied_date,format_mask), null_space) satisfied_date,
8506: decode(sign(md.dmd_satisfied_date - md.using_assembly_demand_date),
8507: 1, GREATEST(round(md.dmd_satisfied_date - md.using_assembly_demand_date,2), 0.01), 0) days_late,
8508: nvl(to_char(md.quantity_by_due_date),null_space) qty_by_due_date,
8509: msc_get_name.org_code(md.organization_id, md.sr_instance_id) org,
8510: nvl(md.demand_class,null_space) demand_class
8511: from msc_demands md
8512: where md.plan_id = p_plan_id
8513: and md.demand_id = v_demand_id

Line 8659: nvl(msc_get_name.job_name(mrr.supply_id, p_plan_id), to_char(mrr.supply_id)) job_name,

8655: to_char(msc_gantt_utils.getResReqStartDate(nvl(mrr.firm_flag,0),
8656: mrr.start_date, mrr.end_date,mrr.firm_start_date, mrr.firm_end_date, mrr.status, mrr.applied), format_mask) start_date,
8657: to_char(msc_gantt_utils.getResReqEndDate(nvl(mrr.firm_flag,0), mrr.start_date, mrr.end_date,
8658: mrr.firm_start_date, mrr.firm_end_date, mrr.status, mrr.applied), format_mask) end_date,
8659: nvl(msc_get_name.job_name(mrr.supply_id, p_plan_id), to_char(mrr.supply_id)) job_name,
8660: msc_get_name.supply_type(mrr.supply_id, mrr.plan_id) supply_type,
8661: mrr.assigned_units,
8662: mrr.transaction_id,
8663: mrr.sr_instance_id

Line 8660: msc_get_name.supply_type(mrr.supply_id, mrr.plan_id) supply_type,

8656: mrr.start_date, mrr.end_date,mrr.firm_start_date, mrr.firm_end_date, mrr.status, mrr.applied), format_mask) start_date,
8657: to_char(msc_gantt_utils.getResReqEndDate(nvl(mrr.firm_flag,0), mrr.start_date, mrr.end_date,
8658: mrr.firm_start_date, mrr.firm_end_date, mrr.status, mrr.applied), format_mask) end_date,
8659: nvl(msc_get_name.job_name(mrr.supply_id, p_plan_id), to_char(mrr.supply_id)) job_name,
8660: msc_get_name.supply_type(mrr.supply_id, mrr.plan_id) supply_type,
8661: mrr.assigned_units,
8662: mrr.transaction_id,
8663: mrr.sr_instance_id
8664: from msc_resource_requirements mrr

Line 8725: nvl(msc_get_name.job_name(mrr.supply_id, p_plan_id), to_char(mrr.supply_id)) job_name,

8721: to_char(msc_gantt_utils.getResReqStartDate(nvl(mrr.firm_flag,0),
8722: mrr.start_date, mrr.end_date,mrr.firm_start_date, mrr.firm_end_date, mrr.status, mrr.applied), format_mask) start_date,
8723: to_char(msc_gantt_utils.getResReqEndDate(nvl(mrr.firm_flag,0), mrr.start_date, mrr.end_date,
8724: mrr.firm_start_date, mrr.firm_end_date, mrr.status, mrr.applied), format_mask) end_date,
8725: nvl(msc_get_name.job_name(mrr.supply_id, p_plan_id), to_char(mrr.supply_id)) job_name,
8726: msc_get_name.supply_type(mrr.supply_id, mrr.plan_id) supply_type,
8727: mrr.assigned_units,
8728: mrr.transaction_id,
8729: mrr.sr_instance_id

Line 8726: msc_get_name.supply_type(mrr.supply_id, mrr.plan_id) supply_type,

8722: mrr.start_date, mrr.end_date,mrr.firm_start_date, mrr.firm_end_date, mrr.status, mrr.applied), format_mask) start_date,
8723: to_char(msc_gantt_utils.getResReqEndDate(nvl(mrr.firm_flag,0), mrr.start_date, mrr.end_date,
8724: mrr.firm_start_date, mrr.firm_end_date, mrr.status, mrr.applied), format_mask) end_date,
8725: nvl(msc_get_name.job_name(mrr.supply_id, p_plan_id), to_char(mrr.supply_id)) job_name,
8726: msc_get_name.supply_type(mrr.supply_id, mrr.plan_id) supply_type,
8727: mrr.assigned_units,
8728: mrr.transaction_id,
8729: mrr.sr_instance_id
8730: from msc_resource_requirements mrr

Line 9165: msc_get_name.org_code(res.organization_id, res.sr_instance_id) ORGANIZATION,

9161: mgq.department_id,
9162: mgq.resource_id,
9163: mgq.res_instance_id,
9164: mgq.serial_number,
9165: msc_get_name.org_code(res.organization_id, res.sr_instance_id) ORGANIZATION,
9166: res.department_code DEPARTMENT,
9167: decode(res.resource_id,-1, null,
9168: msc_get_name.department_code(2, res.owning_department_id,
9169: res.organization_id, res.plan_id,res.sr_instance_id)) OWN_DEPT,

Line 9168: msc_get_name.department_code(2, res.owning_department_id,

9164: mgq.serial_number,
9165: msc_get_name.org_code(res.organization_id, res.sr_instance_id) ORGANIZATION,
9166: res.department_code DEPARTMENT,
9167: decode(res.resource_id,-1, null,
9168: msc_get_name.department_code(2, res.owning_department_id,
9169: res.organization_id, res.plan_id,res.sr_instance_id)) OWN_DEPT,
9170: res.resource_code RESOURCE_CODE,
9171: msc_get_name.lookup_meaning(''BOM_RESOURCE_TYPE'',res.resource_type) RES_TYPE,
9172: msc_gantt_utils.getDeptResInstCode(res.plan_id, res.sr_instance_id, res.organization_id,

Line 9171: msc_get_name.lookup_meaning(''BOM_RESOURCE_TYPE'',res.resource_type) RES_TYPE,

9167: decode(res.resource_id,-1, null,
9168: msc_get_name.department_code(2, res.owning_department_id,
9169: res.organization_id, res.plan_id,res.sr_instance_id)) OWN_DEPT,
9170: res.resource_code RESOURCE_CODE,
9171: msc_get_name.lookup_meaning(''BOM_RESOURCE_TYPE'',res.resource_type) RES_TYPE,
9172: msc_gantt_utils.getDeptResInstCode(res.plan_id, res.sr_instance_id, res.organization_id,
9173: res.department_id, res.resource_id, mgq.res_instance_id, mgq.serial_number) EQUIP_NUMBER
9174: from msc_department_resources res,
9175: msc_gantt_query mgq

Line 9953: msc_get_name.demand_order_number ( md.plan_id, md.sr_instance_id, md.demand_id )

9949:
9950:
9951: --Demand Node Info
9952: sql_stmt := ' select mgq.row_index,
9953: msc_get_name.demand_order_number ( md.plan_id, md.sr_instance_id, md.demand_id )
9954: ||'' for ''||msi.item_name ||'' in '' || mtp.organization_code ORDERS,
9955: mgq.node_type,
9956: mgq.node_path,
9957: mgq.parent_link,

Line 9962: msc_get_name.lookup_meaning(''MRP_DEMAND_ORIGINATION'', md.origination_type) ORDER_TYPE,

9958: nvl(mgq.critical_flag,0) critical_flag,
9959: msi.item_name ITEM,
9960: mtp.organization_code ORGANIZATION,
9961: md.origination_type order_type_id,
9962: msc_get_name.lookup_meaning(''MRP_DEMAND_ORIGINATION'', md.origination_type) ORDER_TYPE,
9963: msc_get_name.demand_order_number ( md.plan_id, md.sr_instance_id, md.demand_id )
9964: ORDER_NUMBER,
9965: decode(md.customer_id, null,
9966: msc_get_name.get_other_customers(md.plan_id, md.schedule_designator_id),

Line 9963: msc_get_name.demand_order_number ( md.plan_id, md.sr_instance_id, md.demand_id )

9959: msi.item_name ITEM,
9960: mtp.organization_code ORGANIZATION,
9961: md.origination_type order_type_id,
9962: msc_get_name.lookup_meaning(''MRP_DEMAND_ORIGINATION'', md.origination_type) ORDER_TYPE,
9963: msc_get_name.demand_order_number ( md.plan_id, md.sr_instance_id, md.demand_id )
9964: ORDER_NUMBER,
9965: decode(md.customer_id, null,
9966: msc_get_name.get_other_customers(md.plan_id, md.schedule_designator_id),
9967: msc_get_name.customer(md.customer_id)) CUSTOMER,

Line 9966: msc_get_name.get_other_customers(md.plan_id, md.schedule_designator_id),

9962: msc_get_name.lookup_meaning(''MRP_DEMAND_ORIGINATION'', md.origination_type) ORDER_TYPE,
9963: msc_get_name.demand_order_number ( md.plan_id, md.sr_instance_id, md.demand_id )
9964: ORDER_NUMBER,
9965: decode(md.customer_id, null,
9966: msc_get_name.get_other_customers(md.plan_id, md.schedule_designator_id),
9967: msc_get_name.customer(md.customer_id)) CUSTOMER,
9968: decode(md.customer_site_id, null,
9969: msc_get_name.get_other_customers(md.plan_id,md.schedule_designator_id),
9970: msc_get_name.customer_site(md.customer_site_id)) CUSTOMER_SITE,

Line 9967: msc_get_name.customer(md.customer_id)) CUSTOMER,

9963: msc_get_name.demand_order_number ( md.plan_id, md.sr_instance_id, md.demand_id )
9964: ORDER_NUMBER,
9965: decode(md.customer_id, null,
9966: msc_get_name.get_other_customers(md.plan_id, md.schedule_designator_id),
9967: msc_get_name.customer(md.customer_id)) CUSTOMER,
9968: decode(md.customer_site_id, null,
9969: msc_get_name.get_other_customers(md.plan_id,md.schedule_designator_id),
9970: msc_get_name.customer_site(md.customer_site_id)) CUSTOMER_SITE,
9971: md.using_assembly_demand_date start_date,

Line 9969: msc_get_name.get_other_customers(md.plan_id,md.schedule_designator_id),

9965: decode(md.customer_id, null,
9966: msc_get_name.get_other_customers(md.plan_id, md.schedule_designator_id),
9967: msc_get_name.customer(md.customer_id)) CUSTOMER,
9968: decode(md.customer_site_id, null,
9969: msc_get_name.get_other_customers(md.plan_id,md.schedule_designator_id),
9970: msc_get_name.customer_site(md.customer_site_id)) CUSTOMER_SITE,
9971: md.using_assembly_demand_date start_date,
9972: nvl(md.dmd_satisfied_date,md.using_assembly_demand_date) end_date,
9973: demand_priority,

Line 9970: msc_get_name.customer_site(md.customer_site_id)) CUSTOMER_SITE,

9966: msc_get_name.get_other_customers(md.plan_id, md.schedule_designator_id),
9967: msc_get_name.customer(md.customer_id)) CUSTOMER,
9968: decode(md.customer_site_id, null,
9969: msc_get_name.get_other_customers(md.plan_id,md.schedule_designator_id),
9970: msc_get_name.customer_site(md.customer_site_id)) CUSTOMER_SITE,
9971: md.using_assembly_demand_date start_date,
9972: nvl(md.dmd_satisfied_date,md.using_assembly_demand_date) end_date,
9973: demand_priority,
9974: --md.quantity_by_due_date QUANTITY,

Line 9978: msc_get_name.item_name(msi.product_family_id,null,null,null) PRODUCT_FAMILY,

9974: --md.quantity_by_due_date QUANTITY,
9975: md.using_requirement_quantity QUANTITY,
9976: msi.description ITEM_DESC,
9977: mic.category_name ITEM_CATEGORY,
9978: msc_get_name.item_name(msi.product_family_id,null,null,null) PRODUCT_FAMILY,
9979: msi.planner_code PLANNER,
9980: md.planning_group PLN_GROUP,
9981: decode(md.project_id, null, null, msc_get_name.project(md.project_id,
9982: md.organization_id, md.plan_id, md.sr_instance_id)) PROJECT,

Line 9981: decode(md.project_id, null, null, msc_get_name.project(md.project_id,

9977: mic.category_name ITEM_CATEGORY,
9978: msc_get_name.item_name(msi.product_family_id,null,null,null) PRODUCT_FAMILY,
9979: msi.planner_code PLANNER,
9980: md.planning_group PLN_GROUP,
9981: decode(md.project_id, null, null, msc_get_name.project(md.project_id,
9982: md.organization_id, md.plan_id, md.sr_instance_id)) PROJECT,
9983: decode(md.task_id, null, null, msc_get_name.task(md.task_id,
9984: md.project_id,md.organization_id, md.plan_id, md.sr_instance_id)) TASK,
9985: md.planned_ship_date SUGG_SHIP_DATE,

Line 9983: decode(md.task_id, null, null, msc_get_name.task(md.task_id,

9979: msi.planner_code PLANNER,
9980: md.planning_group PLN_GROUP,
9981: decode(md.project_id, null, null, msc_get_name.project(md.project_id,
9982: md.organization_id, md.plan_id, md.sr_instance_id)) PROJECT,
9983: decode(md.task_id, null, null, msc_get_name.task(md.task_id,
9984: md.project_id,md.organization_id, md.plan_id, md.sr_instance_id)) TASK,
9985: md.planned_ship_date SUGG_SHIP_DATE,
9986: md.using_assembly_demand_date SUGG_DUE_DATE,
9987: md.ship_method SHIP_METHOD,

Line 10082: decode(ms.order_type, 18, msc_get_name.lookup_meaning(''MRP_ORDER_TYPE'', 18),

10078: end loop; -- }
10079:
10080: --Supply/Co-prod Node Info
10081: sql_stmt := ' select mgq.row_index,
10082: decode(ms.order_type, 18, msc_get_name.lookup_meaning(''MRP_ORDER_TYPE'', 18),
10083: msc_get_name.supply_order_number(ms.order_type, ms.order_number, ms.plan_id,
10084: ms.sr_instance_id, ms.transaction_id, ms.disposition_id)) ||'' for ''||
10085: msi.item_name ||'' in '' || mtp.organization_code ||''(''|| round(ms.new_order_quantity,:round_factor)||'')'' ORDERS,
10086: mgq.node_type,

Line 10083: msc_get_name.supply_order_number(ms.order_type, ms.order_number, ms.plan_id,

10079:
10080: --Supply/Co-prod Node Info
10081: sql_stmt := ' select mgq.row_index,
10082: decode(ms.order_type, 18, msc_get_name.lookup_meaning(''MRP_ORDER_TYPE'', 18),
10083: msc_get_name.supply_order_number(ms.order_type, ms.order_number, ms.plan_id,
10084: ms.sr_instance_id, ms.transaction_id, ms.disposition_id)) ||'' for ''||
10085: msi.item_name ||'' in '' || mtp.organization_code ||''(''|| round(ms.new_order_quantity,:round_factor)||'')'' ORDERS,
10086: mgq.node_type,
10087: mgq.node_path,

Line 10099: msc_get_name.supply_order_number(ms.order_type, ms.order_number, ms.plan_id,

10095: nvl(ms.firm_date, ms.new_schedule_date)),:format_mask) start_date,
10096: nvl(ms.firm_date, ms.new_schedule_date) end_date,
10097: ms.order_type order_type_id,
10098: mfg.meaning ORDER_TYPE,
10099: msc_get_name.supply_order_number(ms.order_type, ms.order_number, ms.plan_id,
10100: ms.sr_instance_id, ms.transaction_id, ms.disposition_id) order_number,
10101: ms.new_order_quantity QUANTITY,
10102: ms.earliest_start_date,
10103: ms.earliest_completion_date,

Line 10119: msc_get_name.item_name(msi.product_family_id,null,null,null) PRODUCT_FAMILY,

10115: nvl(ms.supplier_id, 0) supplier_id,
10116: nvl(ms.supplier_site_id, 0) supplier_site_id,
10117: msi.description ITEM_DESC,
10118: mic.category_name ITEM_CATEGORY,
10119: msc_get_name.item_name(msi.product_family_id,null,null,null) PRODUCT_FAMILY,
10120: msi.planner_code PLANNER,
10121: ms.planning_group PLN_GROUP,
10122: decode(ms.project_id, null, null, msc_get_name.project(ms.project_id,
10123: ms.organization_id, ms.plan_id, ms.sr_instance_id)) PROJECT,

Line 10122: decode(ms.project_id, null, null, msc_get_name.project(ms.project_id,

10118: mic.category_name ITEM_CATEGORY,
10119: msc_get_name.item_name(msi.product_family_id,null,null,null) PRODUCT_FAMILY,
10120: msi.planner_code PLANNER,
10121: ms.planning_group PLN_GROUP,
10122: decode(ms.project_id, null, null, msc_get_name.project(ms.project_id,
10123: ms.organization_id, ms.plan_id, ms.sr_instance_id)) PROJECT,
10124: decode(ms.task_id, null, null, msc_get_name.task(ms.task_id,
10125: ms.project_id, ms.organization_id, ms.plan_id, ms.sr_instance_id)) TASK,
10126: ms.new_order_placement_date SUGG_ORDER_DATE,

Line 10124: decode(ms.task_id, null, null, msc_get_name.task(ms.task_id,

10120: msi.planner_code PLANNER,
10121: ms.planning_group PLN_GROUP,
10122: decode(ms.project_id, null, null, msc_get_name.project(ms.project_id,
10123: ms.organization_id, ms.plan_id, ms.sr_instance_id)) PROJECT,
10124: decode(ms.task_id, null, null, msc_get_name.task(ms.task_id,
10125: ms.project_id, ms.organization_id, ms.plan_id, ms.sr_instance_id)) TASK,
10126: ms.new_order_placement_date SUGG_ORDER_DATE,
10127: ms.new_wip_start_date SUGG_START_DATE,
10128: ms.new_ship_date SUGG_SHIP_DATE,

Line 10131: msc_get_name.org_code(ms.source_organization_id, ms.source_sr_instance_id) SR_ORG,

10127: ms.new_wip_start_date SUGG_START_DATE,
10128: ms.new_ship_date SUGG_SHIP_DATE,
10129: ms.new_dock_date SUGG_DOCK_DATE,
10130: ms.new_schedule_date SUGG_DUE_DATE,
10131: msc_get_name.org_code(ms.source_organization_id, ms.source_sr_instance_id) SR_ORG,
10132: msc_get_name.supplier(ms.supplier_id) SUPPLIER,
10133: msc_get_name.supplier_site(ms.supplier_site_id) SUPPLIER_SITE,
10134: ms.ship_method SHIP_METHOD,
10135: ms.schedule_group_name SCHEDULE_GROUP,

Line 10132: msc_get_name.supplier(ms.supplier_id) SUPPLIER,

10128: ms.new_ship_date SUGG_SHIP_DATE,
10129: ms.new_dock_date SUGG_DOCK_DATE,
10130: ms.new_schedule_date SUGG_DUE_DATE,
10131: msc_get_name.org_code(ms.source_organization_id, ms.source_sr_instance_id) SR_ORG,
10132: msc_get_name.supplier(ms.supplier_id) SUPPLIER,
10133: msc_get_name.supplier_site(ms.supplier_site_id) SUPPLIER_SITE,
10134: ms.ship_method SHIP_METHOD,
10135: ms.schedule_group_name SCHEDULE_GROUP,
10136: ms.transaction_id transaction_id,

Line 10133: msc_get_name.supplier_site(ms.supplier_site_id) SUPPLIER_SITE,

10129: ms.new_dock_date SUGG_DOCK_DATE,
10130: ms.new_schedule_date SUGG_DUE_DATE,
10131: msc_get_name.org_code(ms.source_organization_id, ms.source_sr_instance_id) SR_ORG,
10132: msc_get_name.supplier(ms.supplier_id) SUPPLIER,
10133: msc_get_name.supplier_site(ms.supplier_site_id) SUPPLIER_SITE,
10134: ms.ship_method SHIP_METHOD,
10135: ms.schedule_group_name SCHEDULE_GROUP,
10136: ms.transaction_id transaction_id,
10137: ms.sr_instance_id,

Line 10142: msc_get_name.lookup_meaning(''WIP_JOB_STATUS'', ms.wip_status_code) wip_status_text,

10138: ms.organization_id,
10139: ms.inventory_item_id,
10140: ms.schedule_priority,
10141: msi.description,
10142: msc_get_name.lookup_meaning(''WIP_JOB_STATUS'', ms.wip_status_code) wip_status_text,
10143: ms.new_schedule_date,
10144: ms.actual_start_date
10145: from msc_supplies ms,
10146: msc_system_items msi,

Line 10312: ''(''||msc_get_name.department_resource_code(mrr.resource_id,

10308:
10309: --Resource Node Info
10310: sql_stmt := ' select mgq.row_index,
10311: to_char(mrr.operation_seq_num)||''/''||to_char(mrr.resource_seq_num)||
10312: ''(''||msc_get_name.department_resource_code(mrr.resource_id,
10313: mrr.department_id, mrr.organization_id, mrr.plan_id, mrr.sr_instance_id)||'')'',
10314: mgq.node_type,
10315: mgq.node_path,
10316: mgq.parent_link,

Line 10327: msc_get_name.alternate_rtg(mrr.plan_id, mrr.sr_instance_id, mrr.routing_sequence_id),

10323: ms.new_order_quantity QUANTITY,
10324: mrr.resource_hours adjusted_res_hours,
10325: mrr.batch_number,
10326: mrr.assigned_units,
10327: msc_get_name.alternate_rtg(mrr.plan_id, mrr.sr_instance_id, mrr.routing_sequence_id),
10328: msc_get_name.lookup_meaning(''WIP_JOB_STATUS'', ms.wip_status_code) wip_status_text,
10329: nvl(ms.firm_planned_type,2) supply_firm_type,
10330: nvl(mrr.firm_flag,0) res_firm_type,
10331: nvl(mrr.status, 0) status,

Line 10328: msc_get_name.lookup_meaning(''WIP_JOB_STATUS'', ms.wip_status_code) wip_status_text,

10324: mrr.resource_hours adjusted_res_hours,
10325: mrr.batch_number,
10326: mrr.assigned_units,
10327: msc_get_name.alternate_rtg(mrr.plan_id, mrr.sr_instance_id, mrr.routing_sequence_id),
10328: msc_get_name.lookup_meaning(''WIP_JOB_STATUS'', ms.wip_status_code) wip_status_text,
10329: nvl(ms.firm_planned_type,2) supply_firm_type,
10330: nvl(mrr.firm_flag,0) res_firm_type,
10331: nvl(mrr.status, 0) status,
10332: nvl(mrr.applied, 0) applied,

Line 10351: msc_get_name.supply_order_number(ms.order_type, ms.order_number, ms.plan_id,

10347: mrr.organization_id,
10348: mrr.department_id,
10349: mrr.resource_id,
10350: ms.inventory_item_id,
10351: msc_get_name.supply_order_number(ms.order_type, ms.order_number, ms.plan_id,
10352: ms.sr_instance_id, ms.transaction_id, ms.disposition_id) order_number,
10353: mrr.operation_seq_num,
10354: mdr.resource_description,
10355: mi.item_name item,