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 1419: 14, decode(substr(msc_get_name.get_order_number(p_inst_id, p_plan_id,

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

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

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

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

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

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

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

Line 1451: l_temp := Substr(msc_get_name.get_order_number

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

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

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

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

3231: mrr.uepcd,
3232: mrr.eacd,
3233: msc_gantt_utils.getResActResNodeLabel(mrr.plan_id, mrr.sr_instance_id, mrr.transaction_id) bar_text,
3234: ms.inventory_item_id,
3235: msc_get_name.supply_order_number(ms.order_type, ms.order_number, ms.plan_id,
3236: ms.sr_instance_id, ms.transaction_id, ms.disposition_id) order_number,
3237: mrr.operation_seq_num,
3238: mrr.resource_seq_num,
3239: mdr.resource_description,

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

3242: decode(mrr.resource_hours, 0, to_number(null),
3243: nvl(mrr.cummulative_quantity,ms.new_order_quantity)) schedule_qty,
3244: decode(mrr.from_setup_id,
3245: to_number(null), null,
3246: msc_get_name.setup_code(mrr.plan_id, mrr.sr_instance_id, mrr.resource_id,
3247: mrr.organization_id, mrr.from_setup_id)) from_setup_code,
3248: decode(mrr.setup_id,
3249: to_number(null), null,
3250: msc_get_name.setup_code(mrr.plan_id, mrr.sr_instance_id, mrr.resource_id,

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

3246: msc_get_name.setup_code(mrr.plan_id, mrr.sr_instance_id, mrr.resource_id,
3247: mrr.organization_id, mrr.from_setup_id)) from_setup_code,
3248: decode(mrr.setup_id,
3249: to_number(null), null,
3250: msc_get_name.setup_code(mrr.plan_id, mrr.sr_instance_id, mrr.resource_id,
3251: mrr.organization_id, mrr.setup_id)) to_setup_code,
3252: decode(mrr.from_setup_id,
3253: to_number(null), null,
3254: msc_gantt_utils.getTansitionValue(mrr.plan_id, mrr.sr_instance_id,

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

3351: mrr.uepcd,
3352: mrr.eacd,
3353: msc_gantt_utils.getResActResNodeLabel(mrr.plan_id, mrr.sr_instance_id, mrr.transaction_id) bar_text,
3354: ms.inventory_item_id,
3355: msc_get_name.supply_order_number(ms.order_type, ms.order_number, ms.plan_id,
3356: ms.sr_instance_id, ms.transaction_id, ms.disposition_id) order_number,
3357: mrr.operation_seq_num,
3358: mrr.resource_seq_num,
3359: mdr.resource_description,

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

3362: decode(mrr.resource_hours, 0, to_number(null),
3363: nvl(mrr.cummulative_quantity,ms.new_order_quantity)) schedule_qty,
3364: decode(mrr.from_setup_id,
3365: to_number(null), null,
3366: msc_get_name.setup_code(mrr.plan_id, mrr.sr_instance_id, mrr.resource_id,
3367: mrr.organization_id, mrr.from_setup_id)) from_setup_code,
3368: decode(mrr.setup_id,
3369: to_number(null), null,
3370: msc_get_name.setup_code(mrr.plan_id, mrr.sr_instance_id, mrr.resource_id,

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

3366: msc_get_name.setup_code(mrr.plan_id, mrr.sr_instance_id, mrr.resource_id,
3367: mrr.organization_id, mrr.from_setup_id)) from_setup_code,
3368: decode(mrr.setup_id,
3369: to_number(null), null,
3370: msc_get_name.setup_code(mrr.plan_id, mrr.sr_instance_id, mrr.resource_id,
3371: mrr.organization_id, mrr.setup_id)) to_setup_code,
3372: decode(mrr.from_setup_id,
3373: to_number(null), null,
3374: msc_gantt_utils.getTansitionValue(mrr.plan_id, mrr.sr_instance_id,

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

3462: to_number(null), null_space,
3463: msc_gantt_utils.getSetupCode(mrr.plan_id,
3464: mrr.sr_instance_id, mrr.resource_id, mrr.setup_id)),
3465: null_space),
3466: msc_get_name.org_code(mrr.organization_id, mrr.sr_instance_id),
3467: to_char(sum(ms.new_order_quantity)),
3468: to_char(mrr.batch_number),
3469: to_char(sum(mrr.capacity_consumed_ratio))) bar_text
3470: from msc_resource_requirements mrr,

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

3517: group by mgq.row_index,
3518: mrr.plan_id,
3519: mrr.sr_instance_id,
3520: mrr.organization_id,
3521: msc_get_name.org_code(mrr.organization_id, mrr.sr_instance_id),
3522: mrr.resource_id,
3523: mrr.batch_number,
3524: msc_gantt_utils.getResReqStartDate(nvl(mrr.firm_flag,0), mrr.start_date, mrr.end_date,
3525: mrr.firm_start_date, mrr.firm_end_date, mrr.status, mrr.applied),

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

3544: to_number(null), null_space,
3545: msc_gantt_utils.getSetupCode(mrr.plan_id,
3546: mrr.sr_instance_id, mrr.resource_id, mrr.setup_id)),
3547: null_space),
3548: msc_get_name.org_code(mrr.organization_id, mrr.sr_instance_id),
3549: to_char(sum(ms.new_order_quantity)),
3550: to_char(mrir.batch_number),
3551: to_char(sum(mrir.capacity_consumed_ratio))) bar_text
3552: from msc_resource_instance_reqs mrir,

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

3599: group by mgq.row_index,
3600: mrr.plan_id,
3601: mrr.sr_instance_id,
3602: mrr.organization_id,
3603: msc_get_name.org_code(mrr.organization_id, mrr.sr_instance_id),
3604: mrr.resource_id,
3605: mrir.batch_number,
3606: msc_gantt_utils.getResReqStartDate(nvl(mrr.firm_flag,0), mrir.start_date, mrir.end_date,
3607: mrr.firm_start_date, mrr.firm_end_date, mrr.status, mrr.applied),

Line 4822: msc_get_name.execute_dsql(res_where_stat);

4818: ||' where plan_id = '||p_plan_id
4819: --||' and res_instance_id is null '
4820: ||' and 1=1 '||p_where;
4821:
4822: msc_get_name.execute_dsql(res_where_stat);
4823:
4824: res_where_stat := 'select number1, number2, number3, number4, number5, char1 '
4825: ||' from msc_form_query mfq, '
4826: ||' msc_among_values mav '

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

7135: p_from_form number default null) is
7136:
7137: cursor c_alt_res_res (p_plan number, p_inst number, p_trx number)is
7138: select distinct mor.alternate_number || COLON_SEPARATOR ||
7139: msc_get_name.resource_code(mor.resource_id, mrr.department_id,
7140: mrr.organization_id, mrr.plan_id, mrr.sr_instance_id),
7141: mor.resource_id,
7142: mbp_null_value res_instance_id,
7143: mbp_null_value_char serial_number,

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

7155: and mor.alternate_number <> mrr.alternate_num
7156: and mor.principal_flag <> 2
7157: union all --5478582 bugfix
7158: select distinct mjor.alternate_num || COLON_SEPARATOR ||
7159: msc_get_name.resource_code(mjor.resource_id, mrr.department_id,
7160: mrr.organization_id, mrr.plan_id, mrr.sr_instance_id),
7161: mjor.resource_id,
7162: mbp_null_value res_instance_id,
7163: mbp_null_value_char serial_number,

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

7234:
7235:
7236: cursor c_alt_inst_res (p_plan number, p_inst number, p_trx number)is
7237: select distinct mor.alternate_number
7238: || COLON_SEPARATOR ||msc_get_name.resource_code(mor.resource_id, mrr.department_id,
7239: mrr.organization_id, mrr.plan_id, mrr.sr_instance_id),
7240: mor.resource_id,
7241: mbp_null_value res_instance_id,
7242: mbp_null_value_char serial_number,

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

7254: and mor.alternate_number <> mrr.alternate_num
7255: and mor.principal_flag <> 2
7256: union all --5478582 bugfix
7257: select distinct mjor.alternate_num
7258: || COLON_SEPARATOR ||msc_get_name.resource_code(mjor.resource_id, mrr.department_id,
7259: mrr.organization_id, mrr.plan_id, mrr.sr_instance_id),
7260: mjor.resource_id,
7261: mbp_null_value res_instance_id,
7262: mbp_null_value_char serial_number,

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

7604: p_name OUT NOCOPY varchar2, p_id OUT NOCOPY varchar2,
7605: p_node_type number default null) IS
7606:
7607: cursor c_simu_res_res(p_plan_id number, p_inst_id number, p_trx_id number ) is
7608: select msc_get_name.resource_code(mor.resource_id, mrr.department_id,
7609: mrr.organization_id, mrr.plan_id, mrr.sr_instance_id) resource_code,
7610: mor.resource_id resource_id,
7611: mbp_null_value res_instance_id,
7612: mbp_null_value_char serial_number

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

7647: and mor.sr_instance_id = mdri.sr_instance_id
7648: and mor.resource_id = mdri.resource_id;
7649:
7650: cursor c_simu_inst_res (p_plan number, p_inst number, p_trx number)is
7651: select mor.alternate_number ||':'||msc_get_name.resource_code(mor.resource_id, mrr.department_id,
7652: mrr.organization_id, mrr.plan_id, mrr.sr_instance_id) resource_code,
7653: mor.resource_id,
7654: mbp_null_value res_instance_id,
7655: mbp_null_value_char serial_number

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

8151: nvl(to_char(ms.firm_date,format_mask), null_space) firm_date,
8152: to_char(ms.new_schedule_date,format_mask) sugg_due_date,
8153: nvl(to_char(ms.need_by_date,format_mask), null_space) needby,
8154: nvl(ms.unit_number,null_space) unit_number,
8155: nvl(msc_get_name.project(ms.project_id,ms.organization_id,
8156: ms.plan_id, ms.sr_instance_id), null_space) project,
8157: nvl(msc_get_name.task(ms.task_id, ms.project_id, ms.organization_id,
8158: ms.plan_id, ms.sr_instance_id),null_space) task,
8159: msc_get_name.org_code(ms.organization_id, ms.sr_instance_id) org,

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

8153: nvl(to_char(ms.need_by_date,format_mask), null_space) needby,
8154: nvl(ms.unit_number,null_space) unit_number,
8155: nvl(msc_get_name.project(ms.project_id,ms.organization_id,
8156: ms.plan_id, ms.sr_instance_id), null_space) project,
8157: nvl(msc_get_name.task(ms.task_id, ms.project_id, ms.organization_id,
8158: ms.plan_id, ms.sr_instance_id),null_space) task,
8159: msc_get_name.org_code(ms.organization_id, ms.sr_instance_id) org,
8160: decode(ms.order_type,
8161: 5, decode(ms.order_number,

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

8155: nvl(msc_get_name.project(ms.project_id,ms.organization_id,
8156: ms.plan_id, ms.sr_instance_id), null_space) project,
8157: nvl(msc_get_name.task(ms.task_id, ms.project_id, ms.organization_id,
8158: ms.plan_id, ms.sr_instance_id),null_space) task,
8159: msc_get_name.org_code(ms.organization_id, ms.sr_instance_id) org,
8160: decode(ms.order_type,
8161: 5, decode(ms.order_number,
8162: null, to_char(ms.transaction_id),
8163: replace(ms.order_number,'~','^')||' '||to_char(ms.transaction_id)),

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

8166: nvl(ms.alternate_bom_designator, null_space) alternate_bom_designator,
8167: nvl(ms.alternate_routing_designator, null_space) alternate_routing_designator,
8168: ms.organization_id org_id,
8169: nvl(to_char(msi.planning_time_fence_date, format_mask),null_space) time_fence,
8170: nvl(msc_get_name.supply_type(ms.transaction_id, p_plan_id), null_space) supply_type,
8171: decode(msc_gantt_utils.getSupplyType(ms.order_type, msi.planning_make_buy_code,
8172: ms.organization_id, ms.source_organization_id),
8173: BUY_SUPPLY, l_buy_text,
8174: TRANSFER_SUPPLY, l_transfer_text,

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

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

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

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

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

8176: msi.description,
8177: nvl(msc_get_name.supplier(nvl(ms.source_supplier_id, ms.supplier_id)), null_space) supplier,
8178: nvl(msc_get_name.org_code(ms.source_organization_id, ms.source_sr_instance_id),null_space) source_org,
8179: nvl(ms.ship_method, null_space) ship_method,
8180: msc_get_name.lookup_meaning('SYS_YES_NO', decode(ms.supply_is_shared,1,1,2)) share_supply,
8181: nvl(to_char(ms.EARLIEST_START_DATE,format_mask),null_space) EPSD,
8182: nvl(to_char(ms.EARLIEST_COMPLETION_DATE,format_mask),null_space) EPCD,
8183: nvl(to_char(ms.UEPSD,format_mask),null_space) UEPSD,
8184: nvl(to_char(ms.UEPCD,format_mask),null_space) UEPCD,

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

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

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

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

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

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

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

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

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

8201: msc_get_name.department_code(decode(mrr.resource_id, -1, 1,2),
8202: mrr.department_id, mrr.organization_id, mrr.plan_id, mrr.sr_instance_id) dept_code,
8203: nvl(msc_get_name.job_name(mrr.supply_id, p_plan_id), to_char(mrr.supply_id)) job_name,
8204: nvl(mrr.assigned_units,0) assigned_units,
8205: msc_get_name.lookup_meaning('RESOURCE_FIRM_TYPE', nvl(mrr.firm_flag,0)) firm_flag,
8206: nvl(mrr.alternate_num,0) alternate_num,
8207: nvl(mrr.resource_seq_num,0) res_seq_num,
8208: nvl(msc_get_name.resource_code(mrr.resource_id, mrr.department_id,
8209: mrr.organization_id, mrr.plan_id, mrr.sr_instance_id), null_space) res_code,

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

8204: nvl(mrr.assigned_units,0) assigned_units,
8205: msc_get_name.lookup_meaning('RESOURCE_FIRM_TYPE', nvl(mrr.firm_flag,0)) firm_flag,
8206: nvl(mrr.alternate_num,0) alternate_num,
8207: nvl(mrr.resource_seq_num,0) res_seq_num,
8208: nvl(msc_get_name.resource_code(mrr.resource_id, mrr.department_id,
8209: mrr.organization_id, mrr.plan_id, mrr.sr_instance_id), null_space) res_code,
8210: nvl(mrr.resource_hours,0) resource_hours,
8211: ms.organization_id org_id,
8212: ms.transaction_id trans_id,

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

8215: nvl(to_char(mrr.batch_number), null_space) batch_number,
8216: nvl(mdr.unit_of_measure,null_space) uom,
8217: nvl(decode(mrr.basis_type,
8218: null, null_space,
8219: msc_get_name.lookup_meaning('MSC_RES_BASIS_TYPE',mrr.basis_type)),null_space) basis_type,
8220: nvl(decode(mrr.schedule_flag,
8221: null, null_space,
8222: msc_get_name.lookup_meaning('BOM_RESOURCE_SCHEDULE_TYPE',mrr.schedule_flag)),null_space) schedule_flag,
8223: nvl(to_char(mrr.EARLIEST_START_DATE,format_mask),null_space) EPSD,

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

8218: null, null_space,
8219: msc_get_name.lookup_meaning('MSC_RES_BASIS_TYPE',mrr.basis_type)),null_space) basis_type,
8220: nvl(decode(mrr.schedule_flag,
8221: null, null_space,
8222: msc_get_name.lookup_meaning('BOM_RESOURCE_SCHEDULE_TYPE',mrr.schedule_flag)),null_space) schedule_flag,
8223: nvl(to_char(mrr.EARLIEST_START_DATE,format_mask),null_space) EPSD,
8224: nvl(to_char(mrr.EARLIEST_COMPLETION_DATE,format_mask),null_space) EPCD,
8225: nvl(to_char(mrr.UEPSD,format_mask),null_space) UEPSD,
8226: nvl(to_char(mrr.UEPCD,format_mask),null_space) UEPCD,

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

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

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

8340: nvl(to_char(ms.firm_date,format_mask),null_space) firm_date,
8341: to_char(ms.new_schedule_date,format_mask) sugg_due_date,
8342: nvl(to_char(ms.need_by_date,format_mask),null_space) needby,
8343: nvl(ms.unit_number,null_space) unit_number,
8344: nvl(msc_get_name.project(ms.project_id,ms.organization_id,
8345: ms.plan_id, ms.sr_instance_id), null_space) project,
8346: nvl(msc_get_name.task(ms.task_id, ms.project_id, ms.organization_id,
8347: ms.plan_id, ms.sr_instance_id),null_space) task,
8348: ms.transaction_id,

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

8342: nvl(to_char(ms.need_by_date,format_mask),null_space) needby,
8343: nvl(ms.unit_number,null_space) unit_number,
8344: nvl(msc_get_name.project(ms.project_id,ms.organization_id,
8345: ms.plan_id, ms.sr_instance_id), null_space) project,
8346: nvl(msc_get_name.task(ms.task_id, ms.project_id, ms.organization_id,
8347: ms.plan_id, ms.sr_instance_id),null_space) task,
8348: ms.transaction_id,
8349: ms.organization_id,
8350: msc_get_name.org_code(mdr.organization_id, mdr.sr_instance_id) org,

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

8346: nvl(msc_get_name.task(ms.task_id, ms.project_id, ms.organization_id,
8347: ms.plan_id, ms.sr_instance_id),null_space) task,
8348: ms.transaction_id,
8349: ms.organization_id,
8350: msc_get_name.org_code(mdr.organization_id, mdr.sr_instance_id) org,
8351: mdr.department_code,
8352: decode(ms.order_type,
8353: 5, decode(ms.order_number,
8354: null,to_char(ms.transaction_id),

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

8354: null,to_char(ms.transaction_id),
8355: replace(ms.order_number,'~','^')||' '||to_char(ms.transaction_id)),
8356: nvl(replace(ms.order_number,'~','^'),to_char(ms.transaction_id))) job_name,
8357: mrr.assigned_units,
8358: nvl(msc_get_name.lookup_meaning('RESOURCE_FIRM_TYPE',nvl(mrr.firm_flag,NO_FIRM)),
8359: msc_get_name.lookup_meaning('RESOURCE_FIRM_TYPE',0))
8360: firm_flag,
8361: ms.firm_planned_type,
8362: nvl(mrr.alternate_num,0) alternate_num,

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

8355: replace(ms.order_number,'~','^')||' '||to_char(ms.transaction_id)),
8356: nvl(replace(ms.order_number,'~','^'),to_char(ms.transaction_id))) job_name,
8357: mrr.assigned_units,
8358: nvl(msc_get_name.lookup_meaning('RESOURCE_FIRM_TYPE',nvl(mrr.firm_flag,NO_FIRM)),
8359: msc_get_name.lookup_meaning('RESOURCE_FIRM_TYPE',0))
8360: firm_flag,
8361: ms.firm_planned_type,
8362: nvl(mrr.alternate_num,0) alternate_num,
8363: mrr.resource_seq_num,

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

8362: nvl(mrr.alternate_num,0) alternate_num,
8363: mrr.resource_seq_num,
8364: nvl(mdr.resource_code, null_space) resource_code,
8365: mrr.resource_hours,
8366: nvl(msc_get_name.alternate_bom(pe.plan_id, pe.sr_instance_id,
8367: pe.bill_sequence_id),null_space) alternate_bom_designator,
8368: nvl(msc_get_name.alternate_bom(pe.plan_id, pe.sr_instance_id,
8369: pe.bill_sequence_id),null_space) alternate_routing_designator,
8370: nvl(to_char(msi.planning_time_fence_date, format_mask),null_space) time_fence,

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

8364: nvl(mdr.resource_code, null_space) resource_code,
8365: mrr.resource_hours,
8366: nvl(msc_get_name.alternate_bom(pe.plan_id, pe.sr_instance_id,
8367: pe.bill_sequence_id),null_space) alternate_bom_designator,
8368: nvl(msc_get_name.alternate_bom(pe.plan_id, pe.sr_instance_id,
8369: pe.bill_sequence_id),null_space) alternate_routing_designator,
8370: nvl(to_char(msi.planning_time_fence_date, format_mask),null_space) time_fence,
8371: 0 mtq_time, --getMTQTime(p_transaction_id, p_plan_id, p_instance_id) mtq_time,
8372: nvl(mdr.batchable_flag, 2) batchable,

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

8373: nvl(to_char(mrr.batch_number), null_space) batch_number,
8374: nvl(mdr.unit_of_measure,null_space) uom,
8375: nvl(decode(to_char(mrr.basis_type),
8376: null, null_space,
8377: msc_get_name.lookup_meaning('MSC_RES_BASIS_TYPE',mrr.basis_type)),null_space) basis_type,
8378: nvl(decode(to_char(mrr.schedule_flag),
8379: null, null_space,
8380: msc_get_name.lookup_meaning('BOM_RESOURCE_SCHEDULE_TYPE',mrr.schedule_flag)),null_space) schedule_flag,
8381: nvl(to_char(mrr.EARLIEST_START_DATE,format_mask),null_space) EPSD,

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

8376: null, null_space,
8377: msc_get_name.lookup_meaning('MSC_RES_BASIS_TYPE',mrr.basis_type)),null_space) basis_type,
8378: nvl(decode(to_char(mrr.schedule_flag),
8379: null, null_space,
8380: msc_get_name.lookup_meaning('BOM_RESOURCE_SCHEDULE_TYPE',mrr.schedule_flag)),null_space) schedule_flag,
8381: nvl(to_char(mrr.EARLIEST_START_DATE,format_mask),null_space) EPSD,
8382: nvl(to_char(mrr.EARLIEST_COMPLETION_DATE,format_mask),null_space) EPCD,
8383: nvl(to_char(mrr.UEPSD,format_mask),null_space) UEPSD,
8384: nvl(to_char(mrr.UEPCD,format_mask),null_space) UEPCD,

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

8482:
8483: cursor other_demand is
8484: select nvl(v_demand_quantity,0) qty,
8485: nvl(to_char(v_demand_date,format_mask), null_space) demand_date,
8486: msc_get_name.lookup_meaning('MRP_FLP_SUPPLY_DEMAND_TYPE', v_demand_id) type,
8487: item_name item
8488: from msc_items
8489: where inventory_item_id = v_item_id;
8490:

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

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

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

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

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

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

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

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

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

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

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

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

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

8650: to_char(msc_gantt_utils.getResReqStartDate(nvl(mrr.firm_flag,0),
8651: mrr.start_date, mrr.end_date,mrr.firm_start_date, mrr.firm_end_date, mrr.status, mrr.applied), format_mask) start_date,
8652: to_char(msc_gantt_utils.getResReqEndDate(nvl(mrr.firm_flag,0), mrr.start_date, mrr.end_date,
8653: mrr.firm_start_date, mrr.firm_end_date, mrr.status, mrr.applied), format_mask) end_date,
8654: nvl(msc_get_name.job_name(mrr.supply_id, p_plan_id), to_char(mrr.supply_id)) job_name,
8655: msc_get_name.supply_type(mrr.supply_id, mrr.plan_id) supply_type,
8656: mrr.assigned_units,
8657: mrr.transaction_id,
8658: mrr.sr_instance_id

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

8651: mrr.start_date, mrr.end_date,mrr.firm_start_date, mrr.firm_end_date, mrr.status, mrr.applied), format_mask) start_date,
8652: to_char(msc_gantt_utils.getResReqEndDate(nvl(mrr.firm_flag,0), mrr.start_date, mrr.end_date,
8653: mrr.firm_start_date, mrr.firm_end_date, mrr.status, mrr.applied), format_mask) end_date,
8654: nvl(msc_get_name.job_name(mrr.supply_id, p_plan_id), to_char(mrr.supply_id)) job_name,
8655: msc_get_name.supply_type(mrr.supply_id, mrr.plan_id) supply_type,
8656: mrr.assigned_units,
8657: mrr.transaction_id,
8658: mrr.sr_instance_id
8659: from msc_resource_requirements mrr

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

8716: to_char(msc_gantt_utils.getResReqStartDate(nvl(mrr.firm_flag,0),
8717: mrr.start_date, mrr.end_date,mrr.firm_start_date, mrr.firm_end_date, mrr.status, mrr.applied), format_mask) start_date,
8718: to_char(msc_gantt_utils.getResReqEndDate(nvl(mrr.firm_flag,0), mrr.start_date, mrr.end_date,
8719: mrr.firm_start_date, mrr.firm_end_date, mrr.status, mrr.applied), format_mask) end_date,
8720: nvl(msc_get_name.job_name(mrr.supply_id, p_plan_id), to_char(mrr.supply_id)) job_name,
8721: msc_get_name.supply_type(mrr.supply_id, mrr.plan_id) supply_type,
8722: mrr.assigned_units,
8723: mrr.transaction_id,
8724: mrr.sr_instance_id

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

8717: mrr.start_date, mrr.end_date,mrr.firm_start_date, mrr.firm_end_date, mrr.status, mrr.applied), format_mask) start_date,
8718: to_char(msc_gantt_utils.getResReqEndDate(nvl(mrr.firm_flag,0), mrr.start_date, mrr.end_date,
8719: mrr.firm_start_date, mrr.firm_end_date, mrr.status, mrr.applied), format_mask) end_date,
8720: nvl(msc_get_name.job_name(mrr.supply_id, p_plan_id), to_char(mrr.supply_id)) job_name,
8721: msc_get_name.supply_type(mrr.supply_id, mrr.plan_id) supply_type,
8722: mrr.assigned_units,
8723: mrr.transaction_id,
8724: mrr.sr_instance_id
8725: from msc_resource_requirements mrr

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

9156: mgq.department_id,
9157: mgq.resource_id,
9158: mgq.res_instance_id,
9159: mgq.serial_number,
9160: msc_get_name.org_code(res.organization_id, res.sr_instance_id) ORGANIZATION,
9161: res.department_code DEPARTMENT,
9162: decode(res.resource_id,-1, null,
9163: msc_get_name.department_code(2, res.owning_department_id,
9164: res.organization_id, res.plan_id,res.sr_instance_id)) OWN_DEPT,

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

9159: mgq.serial_number,
9160: msc_get_name.org_code(res.organization_id, res.sr_instance_id) ORGANIZATION,
9161: res.department_code DEPARTMENT,
9162: decode(res.resource_id,-1, null,
9163: msc_get_name.department_code(2, res.owning_department_id,
9164: res.organization_id, res.plan_id,res.sr_instance_id)) OWN_DEPT,
9165: res.resource_code RESOURCE_CODE,
9166: msc_get_name.lookup_meaning(''BOM_RESOURCE_TYPE'',res.resource_type) RES_TYPE,
9167: msc_gantt_utils.getDeptResInstCode(res.plan_id, res.sr_instance_id, res.organization_id,

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

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

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

9944:
9945:
9946: --Demand Node Info
9947: sql_stmt := ' select mgq.row_index,
9948: msc_get_name.demand_order_number ( md.plan_id, md.sr_instance_id, md.demand_id )
9949: ||'' for ''||msi.item_name ||'' in '' || mtp.organization_code ORDERS,
9950: mgq.node_type,
9951: mgq.node_path,
9952: mgq.parent_link,

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

9953: nvl(mgq.critical_flag,0) critical_flag,
9954: msi.item_name ITEM,
9955: mtp.organization_code ORGANIZATION,
9956: md.origination_type order_type_id,
9957: msc_get_name.lookup_meaning(''MRP_DEMAND_ORIGINATION'', md.origination_type) ORDER_TYPE,
9958: msc_get_name.demand_order_number ( md.plan_id, md.sr_instance_id, md.demand_id )
9959: ORDER_NUMBER,
9960: decode(md.customer_id, null,
9961: msc_get_name.get_other_customers(md.plan_id, md.schedule_designator_id),

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

9954: msi.item_name ITEM,
9955: mtp.organization_code ORGANIZATION,
9956: md.origination_type order_type_id,
9957: msc_get_name.lookup_meaning(''MRP_DEMAND_ORIGINATION'', md.origination_type) ORDER_TYPE,
9958: msc_get_name.demand_order_number ( md.plan_id, md.sr_instance_id, md.demand_id )
9959: ORDER_NUMBER,
9960: decode(md.customer_id, null,
9961: msc_get_name.get_other_customers(md.plan_id, md.schedule_designator_id),
9962: msc_get_name.customer(md.customer_id)) CUSTOMER,

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

9957: msc_get_name.lookup_meaning(''MRP_DEMAND_ORIGINATION'', md.origination_type) ORDER_TYPE,
9958: msc_get_name.demand_order_number ( md.plan_id, md.sr_instance_id, md.demand_id )
9959: ORDER_NUMBER,
9960: decode(md.customer_id, null,
9961: msc_get_name.get_other_customers(md.plan_id, md.schedule_designator_id),
9962: msc_get_name.customer(md.customer_id)) CUSTOMER,
9963: decode(md.customer_site_id, null,
9964: msc_get_name.get_other_customers(md.plan_id,md.schedule_designator_id),
9965: msc_get_name.customer_site(md.customer_site_id)) CUSTOMER_SITE,

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

9958: msc_get_name.demand_order_number ( md.plan_id, md.sr_instance_id, md.demand_id )
9959: ORDER_NUMBER,
9960: decode(md.customer_id, null,
9961: msc_get_name.get_other_customers(md.plan_id, md.schedule_designator_id),
9962: msc_get_name.customer(md.customer_id)) CUSTOMER,
9963: decode(md.customer_site_id, null,
9964: msc_get_name.get_other_customers(md.plan_id,md.schedule_designator_id),
9965: msc_get_name.customer_site(md.customer_site_id)) CUSTOMER_SITE,
9966: md.using_assembly_demand_date start_date,

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

9960: decode(md.customer_id, null,
9961: msc_get_name.get_other_customers(md.plan_id, md.schedule_designator_id),
9962: msc_get_name.customer(md.customer_id)) CUSTOMER,
9963: decode(md.customer_site_id, null,
9964: msc_get_name.get_other_customers(md.plan_id,md.schedule_designator_id),
9965: msc_get_name.customer_site(md.customer_site_id)) CUSTOMER_SITE,
9966: md.using_assembly_demand_date start_date,
9967: nvl(md.dmd_satisfied_date,md.using_assembly_demand_date) end_date,
9968: demand_priority,

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

9961: msc_get_name.get_other_customers(md.plan_id, md.schedule_designator_id),
9962: msc_get_name.customer(md.customer_id)) CUSTOMER,
9963: decode(md.customer_site_id, null,
9964: msc_get_name.get_other_customers(md.plan_id,md.schedule_designator_id),
9965: msc_get_name.customer_site(md.customer_site_id)) CUSTOMER_SITE,
9966: md.using_assembly_demand_date start_date,
9967: nvl(md.dmd_satisfied_date,md.using_assembly_demand_date) end_date,
9968: demand_priority,
9969: --md.quantity_by_due_date QUANTITY,

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

9969: --md.quantity_by_due_date QUANTITY,
9970: md.using_requirement_quantity QUANTITY,
9971: msi.description ITEM_DESC,
9972: mic.category_name ITEM_CATEGORY,
9973: msc_get_name.item_name(msi.product_family_id,null,null,null) PRODUCT_FAMILY,
9974: msi.planner_code PLANNER,
9975: md.planning_group PLN_GROUP,
9976: decode(md.project_id, null, null, msc_get_name.project(md.project_id,
9977: md.organization_id, md.plan_id, md.sr_instance_id)) PROJECT,

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

9972: mic.category_name ITEM_CATEGORY,
9973: msc_get_name.item_name(msi.product_family_id,null,null,null) PRODUCT_FAMILY,
9974: msi.planner_code PLANNER,
9975: md.planning_group PLN_GROUP,
9976: decode(md.project_id, null, null, msc_get_name.project(md.project_id,
9977: md.organization_id, md.plan_id, md.sr_instance_id)) PROJECT,
9978: decode(md.task_id, null, null, msc_get_name.task(md.task_id,
9979: md.project_id,md.organization_id, md.plan_id, md.sr_instance_id)) TASK,
9980: md.planned_ship_date SUGG_SHIP_DATE,

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

9974: msi.planner_code PLANNER,
9975: md.planning_group PLN_GROUP,
9976: decode(md.project_id, null, null, msc_get_name.project(md.project_id,
9977: md.organization_id, md.plan_id, md.sr_instance_id)) PROJECT,
9978: decode(md.task_id, null, null, msc_get_name.task(md.task_id,
9979: md.project_id,md.organization_id, md.plan_id, md.sr_instance_id)) TASK,
9980: md.planned_ship_date SUGG_SHIP_DATE,
9981: md.using_assembly_demand_date SUGG_DUE_DATE,
9982: md.ship_method SHIP_METHOD,

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

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

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

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

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

10090: nvl(ms.firm_date, ms.new_schedule_date)),:format_mask) start_date,
10091: nvl(ms.firm_date, ms.new_schedule_date) end_date,
10092: ms.order_type order_type_id,
10093: mfg.meaning ORDER_TYPE,
10094: msc_get_name.supply_order_number(ms.order_type, ms.order_number, ms.plan_id,
10095: ms.sr_instance_id, ms.transaction_id, ms.disposition_id) order_number,
10096: ms.new_order_quantity QUANTITY,
10097: ms.earliest_start_date,
10098: ms.earliest_completion_date,

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

10110: nvl(ms.supplier_id, 0) supplier_id,
10111: nvl(ms.supplier_site_id, 0) supplier_site_id,
10112: msi.description ITEM_DESC,
10113: mic.category_name ITEM_CATEGORY,
10114: msc_get_name.item_name(msi.product_family_id,null,null,null) PRODUCT_FAMILY,
10115: msi.planner_code PLANNER,
10116: ms.planning_group PLN_GROUP,
10117: decode(ms.project_id, null, null, msc_get_name.project(ms.project_id,
10118: ms.organization_id, ms.plan_id, ms.sr_instance_id)) PROJECT,

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

10113: mic.category_name ITEM_CATEGORY,
10114: msc_get_name.item_name(msi.product_family_id,null,null,null) PRODUCT_FAMILY,
10115: msi.planner_code PLANNER,
10116: ms.planning_group PLN_GROUP,
10117: decode(ms.project_id, null, null, msc_get_name.project(ms.project_id,
10118: ms.organization_id, ms.plan_id, ms.sr_instance_id)) PROJECT,
10119: decode(ms.task_id, null, null, msc_get_name.task(ms.task_id,
10120: ms.project_id, ms.organization_id, ms.plan_id, ms.sr_instance_id)) TASK,
10121: ms.new_order_placement_date SUGG_ORDER_DATE,

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

10115: msi.planner_code PLANNER,
10116: ms.planning_group PLN_GROUP,
10117: decode(ms.project_id, null, null, msc_get_name.project(ms.project_id,
10118: ms.organization_id, ms.plan_id, ms.sr_instance_id)) PROJECT,
10119: decode(ms.task_id, null, null, msc_get_name.task(ms.task_id,
10120: ms.project_id, ms.organization_id, ms.plan_id, ms.sr_instance_id)) TASK,
10121: ms.new_order_placement_date SUGG_ORDER_DATE,
10122: ms.new_wip_start_date SUGG_START_DATE,
10123: ms.new_ship_date SUGG_SHIP_DATE,

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

10122: ms.new_wip_start_date SUGG_START_DATE,
10123: ms.new_ship_date SUGG_SHIP_DATE,
10124: ms.new_dock_date SUGG_DOCK_DATE,
10125: ms.new_schedule_date SUGG_DUE_DATE,
10126: msc_get_name.org_code(ms.source_organization_id, ms.source_sr_instance_id) SR_ORG,
10127: msc_get_name.supplier(ms.supplier_id) SUPPLIER,
10128: msc_get_name.supplier_site(ms.supplier_site_id) SUPPLIER_SITE,
10129: ms.ship_method SHIP_METHOD,
10130: ms.schedule_group_name SCHEDULE_GROUP,

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

10123: ms.new_ship_date SUGG_SHIP_DATE,
10124: ms.new_dock_date SUGG_DOCK_DATE,
10125: ms.new_schedule_date SUGG_DUE_DATE,
10126: msc_get_name.org_code(ms.source_organization_id, ms.source_sr_instance_id) SR_ORG,
10127: msc_get_name.supplier(ms.supplier_id) SUPPLIER,
10128: msc_get_name.supplier_site(ms.supplier_site_id) SUPPLIER_SITE,
10129: ms.ship_method SHIP_METHOD,
10130: ms.schedule_group_name SCHEDULE_GROUP,
10131: ms.transaction_id transaction_id,

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

10124: ms.new_dock_date SUGG_DOCK_DATE,
10125: ms.new_schedule_date SUGG_DUE_DATE,
10126: msc_get_name.org_code(ms.source_organization_id, ms.source_sr_instance_id) SR_ORG,
10127: msc_get_name.supplier(ms.supplier_id) SUPPLIER,
10128: msc_get_name.supplier_site(ms.supplier_site_id) SUPPLIER_SITE,
10129: ms.ship_method SHIP_METHOD,
10130: ms.schedule_group_name SCHEDULE_GROUP,
10131: ms.transaction_id transaction_id,
10132: ms.sr_instance_id,

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

10133: ms.organization_id,
10134: ms.inventory_item_id,
10135: ms.schedule_priority,
10136: msi.description,
10137: msc_get_name.lookup_meaning(''WIP_JOB_STATUS'', ms.wip_status_code) wip_status_text,
10138: ms.new_schedule_date,
10139: ms.actual_start_date
10140: from msc_supplies ms,
10141: msc_system_items msi,

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

10303:
10304: --Resource Node Info
10305: sql_stmt := ' select mgq.row_index,
10306: to_char(mrr.operation_seq_num)||''/''||to_char(mrr.resource_seq_num)||
10307: ''(''||msc_get_name.department_resource_code(mrr.resource_id,
10308: mrr.department_id, mrr.organization_id, mrr.plan_id, mrr.sr_instance_id)||'')'',
10309: mgq.node_type,
10310: mgq.node_path,
10311: mgq.parent_link,

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

10318: ms.new_order_quantity QUANTITY,
10319: mrr.resource_hours adjusted_res_hours,
10320: mrr.batch_number,
10321: mrr.assigned_units,
10322: msc_get_name.alternate_rtg(mrr.plan_id, mrr.sr_instance_id, mrr.routing_sequence_id),
10323: msc_get_name.lookup_meaning(''WIP_JOB_STATUS'', ms.wip_status_code) wip_status_text,
10324: nvl(ms.firm_planned_type,2) supply_firm_type,
10325: nvl(mrr.firm_flag,0) res_firm_type,
10326: nvl(mrr.status, 0) status,

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

10319: mrr.resource_hours adjusted_res_hours,
10320: mrr.batch_number,
10321: mrr.assigned_units,
10322: msc_get_name.alternate_rtg(mrr.plan_id, mrr.sr_instance_id, mrr.routing_sequence_id),
10323: msc_get_name.lookup_meaning(''WIP_JOB_STATUS'', ms.wip_status_code) wip_status_text,
10324: nvl(ms.firm_planned_type,2) supply_firm_type,
10325: nvl(mrr.firm_flag,0) res_firm_type,
10326: nvl(mrr.status, 0) status,
10327: nvl(mrr.applied, 0) applied,

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

10342: mrr.organization_id,
10343: mrr.department_id,
10344: mrr.resource_id,
10345: ms.inventory_item_id,
10346: msc_get_name.supply_order_number(ms.order_type, ms.order_number, ms.plan_id,
10347: ms.sr_instance_id, ms.transaction_id, ms.disposition_id) order_number,
10348: mrr.operation_seq_num,
10349: mdr.resource_description,
10350: mi.item_name item,