APPS.MSC_GET_GANTT_DATA dependencies on MSC_GET_NAME

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

1612: v_id OUT NOCOPY varchar2) IS
1613:
1614: CURSOR alt_res IS
1615: SELECT mor.alternate_number ||':'||
1616: msc_get_name.resource_code(mor.resource_id, mrr.department_id,
1617: mrr.organization_id, mrr.plan_id,
1618: mrr.sr_instance_id),
1619: mor.resource_id,
1620: mor.alternate_number

Line 1753: SELECT msc_get_name.resource_code(mor.resource_id, mrr.department_id,

1749: v_name OUT NOCOPY varchar2,
1750: v_id OUT NOCOPY varchar2) IS
1751:
1752: CURSOR smu_res IS
1753: SELECT msc_get_name.resource_code(mor.resource_id, mrr.department_id,
1754: mrr.organization_id, mrr.plan_id,
1755: mrr.sr_instance_id),
1756: mor.resource_id
1757: FROM msc_operation_resources mor,

Line 1802: SELECT msc_get_name.item_name(ms.inventory_item_id,null,null,null) item,

1798: v_job OUT NOCOPY varchar2,
1799: v_demand OUT NOCOPY varchar2) IS
1800:
1801: CURSOR property IS
1802: SELECT msc_get_name.item_name(ms.inventory_item_id,null,null,null) item,
1803: mrr.operation_seq_num,
1804: ms.new_order_quantity qty,
1805: nvl(to_char(ms.firm_date,format_mask),' ') firm_date,
1806: to_char(ms.new_schedule_date,format_mask) sugg_due_date,

Line 1809: nvl(msc_get_name.project(ms.project_id,

1805: nvl(to_char(ms.firm_date,format_mask),' ') firm_date,
1806: to_char(ms.new_schedule_date,format_mask) sugg_due_date,
1807: nvl(to_char(ms.need_by_date,format_mask),' ') needby,
1808: nvl(ms.unit_number,'null') unit_number,
1809: nvl(msc_get_name.project(ms.project_id,
1810: ms.organization_id,
1811: ms.plan_id,
1812: ms.sr_instance_id), 'null') project,
1813: nvl(msc_get_name.task( ms.task_id,

Line 1813: nvl(msc_get_name.task( ms.task_id,

1809: nvl(msc_get_name.project(ms.project_id,
1810: ms.organization_id,
1811: ms.plan_id,
1812: ms.sr_instance_id), 'null') project,
1813: nvl(msc_get_name.task( ms.task_id,
1814: ms.project_id,
1815: ms.organization_id,
1816: ms.plan_id,
1817: ms.sr_instance_id),'null') task,

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

1816: ms.plan_id,
1817: ms.sr_instance_id),'null') task,
1818: ms.transaction_id,
1819: ms.organization_id,
1820: msc_get_name.org_code(mdr.organization_id, mdr.sr_instance_id) org,
1821: mdr.department_code,
1822: msc_get_gantt_data.order_number(ms.order_type,ms.order_number,
1823: ms.plan_id, ms.sr_instance_id,
1824: ms.transaction_id, ms.disposition_id) job_name,

Line 1826: nvl(msc_get_name.lookup_meaning('RESOURCE_FIRM_TYPE',

1822: msc_get_gantt_data.order_number(ms.order_type,ms.order_number,
1823: ms.plan_id, ms.sr_instance_id,
1824: ms.transaction_id, ms.disposition_id) job_name,
1825: mrr.assigned_units,
1826: nvl(msc_get_name.lookup_meaning('RESOURCE_FIRM_TYPE',
1827: nvl(mrr.firm_flag,NO_FIRM)),
1828: msc_get_name.lookup_meaning('RESOURCE_FIRM_TYPE',0))
1829: firm_flag,
1830: ms.firm_planned_type,

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

1824: ms.transaction_id, ms.disposition_id) job_name,
1825: mrr.assigned_units,
1826: nvl(msc_get_name.lookup_meaning('RESOURCE_FIRM_TYPE',
1827: nvl(mrr.firm_flag,NO_FIRM)),
1828: msc_get_name.lookup_meaning('RESOURCE_FIRM_TYPE',0))
1829: firm_flag,
1830: ms.firm_planned_type,
1831: nvl(mrr.alternate_num,0) alternate_num,
1832: mrr.resource_seq_num,

Line 1835: nvl(msc_get_name.alternate_bom(pe.plan_id, pe.sr_instance_id,pe.bill_sequence_id),

1831: nvl(mrr.alternate_num,0) alternate_num,
1832: mrr.resource_seq_num,
1833: nvl(mdr.resource_code, 'null') resource_code,
1834: mrr.resource_hours,
1835: nvl(msc_get_name.alternate_bom(pe.plan_id, pe.sr_instance_id,pe.bill_sequence_id),
1836: 'null')
1837: alternate_bom_designator,
1838: nvl(msc_get_name.alternate_bom(pe.plan_id, pe.sr_instance_id,pe.bill_sequence_id),
1839: 'null')

Line 1838: nvl(msc_get_name.alternate_bom(pe.plan_id, pe.sr_instance_id,pe.bill_sequence_id),

1834: mrr.resource_hours,
1835: nvl(msc_get_name.alternate_bom(pe.plan_id, pe.sr_instance_id,pe.bill_sequence_id),
1836: 'null')
1837: alternate_bom_designator,
1838: nvl(msc_get_name.alternate_bom(pe.plan_id, pe.sr_instance_id,pe.bill_sequence_id),
1839: 'null')
1840: alternate_routing_designator,
1841: nvl(to_char(msi.planning_time_fence_date, format_mask),' ') time_fence,
1842: 0 mtq_time, --get_MTQ_time(p_transaction_id, p_plan_id, p_instance_id) mtq_time,

Line 1847: msc_get_name.lookup_meaning(

1843: nvl(mdr.batchable_flag, 2) batchable,
1844: nvl(mrr.batch_number, -1) batch_number,
1845: nvl(mdr.unit_of_measure,'-1') uom,
1846: nvl(decode(mrr.basis_type, null, '-1',
1847: msc_get_name.lookup_meaning(
1848: 'MSC_RES_BASIS_TYPE',mrr.basis_type)),'-1') basis_type,
1849: nvl(decode(mrr.schedule_flag, null, '-1',
1850: msc_get_name.lookup_meaning(
1851: 'BOM_RESOURCE_SCHEDULE_TYPE',mrr.schedule_flag)),'-1') schedule_flag,

Line 1850: msc_get_name.lookup_meaning(

1846: nvl(decode(mrr.basis_type, null, '-1',
1847: msc_get_name.lookup_meaning(
1848: 'MSC_RES_BASIS_TYPE',mrr.basis_type)),'-1') basis_type,
1849: nvl(decode(mrr.schedule_flag, null, '-1',
1850: msc_get_name.lookup_meaning(
1851: 'BOM_RESOURCE_SCHEDULE_TYPE',mrr.schedule_flag)),'-1') schedule_flag,
1852: nvl(to_char(mrr.EARLIEST_START_DATE,format_mask),'null') EPSD,
1853: nvl(to_char(mrr.EARLIEST_COMPLETION_DATE,format_mask),'null') EPCD,
1854: nvl(to_char(mrr.UEPSD,format_mask),'null') UEPSD,

Line 1968: msc_get_name.lookup_meaning('MRP_FLP_SUPPLY_DEMAND_TYPE',

1964: CURSOR other_demand IS
1965: SELECT nvl(v_demand_quantity,0) qty,
1966: nvl(to_char(v_demand_date,
1967: format_mask), 'null') demand_date,
1968: msc_get_name.lookup_meaning('MRP_FLP_SUPPLY_DEMAND_TYPE',
1969: v_demand_id) type,
1970: item_name item
1971: FROM msc_items
1972: WHERE inventory_item_id = v_item_id;

Line 1979: msc_get_name.designator(md.schedule_designator_id)),

1975: SELECT md.using_requirement_quantity qty,
1976: to_char(md.using_assembly_demand_date,
1977: format_mask) demand_date,
1978: nvl(decode(md.schedule_designator_id, null, md.order_number,
1979: msc_get_name.designator(md.schedule_designator_id)),
1980: 'null') name,
1981: msc_get_name.lookup_meaning('MRP_DEMAND_ORIGINATION',
1982: md.origination_type) type,
1983: msc_get_name.item_name(md.inventory_item_id, null,null,null) item,

Line 1981: msc_get_name.lookup_meaning('MRP_DEMAND_ORIGINATION',

1977: format_mask) demand_date,
1978: nvl(decode(md.schedule_designator_id, null, md.order_number,
1979: msc_get_name.designator(md.schedule_designator_id)),
1980: 'null') name,
1981: msc_get_name.lookup_meaning('MRP_DEMAND_ORIGINATION',
1982: md.origination_type) type,
1983: msc_get_name.item_name(md.inventory_item_id, null,null,null) item,
1984: nvl(md.demand_priority,0) priority,
1985: nvl(msc_get_name.customer(md.customer_id),

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

1979: msc_get_name.designator(md.schedule_designator_id)),
1980: 'null') name,
1981: msc_get_name.lookup_meaning('MRP_DEMAND_ORIGINATION',
1982: md.origination_type) type,
1983: msc_get_name.item_name(md.inventory_item_id, null,null,null) item,
1984: nvl(md.demand_priority,0) priority,
1985: nvl(msc_get_name.customer(md.customer_id),
1986: 'null') customer,
1987: nvl(msc_get_name.customer_site(md.customer_site_id),

Line 1985: nvl(msc_get_name.customer(md.customer_id),

1981: msc_get_name.lookup_meaning('MRP_DEMAND_ORIGINATION',
1982: md.origination_type) type,
1983: msc_get_name.item_name(md.inventory_item_id, null,null,null) item,
1984: nvl(md.demand_priority,0) priority,
1985: nvl(msc_get_name.customer(md.customer_id),
1986: 'null') customer,
1987: nvl(msc_get_name.customer_site(md.customer_site_id),
1988: 'null') customer_site,
1989: nvl(to_char(md.dmd_satisfied_date,format_mask),

Line 1987: nvl(msc_get_name.customer_site(md.customer_site_id),

1983: msc_get_name.item_name(md.inventory_item_id, null,null,null) item,
1984: nvl(md.demand_priority,0) priority,
1985: nvl(msc_get_name.customer(md.customer_id),
1986: 'null') customer,
1987: nvl(msc_get_name.customer_site(md.customer_site_id),
1988: 'null') customer_site,
1989: nvl(to_char(md.dmd_satisfied_date,format_mask),
1990: 'null') satisfied_date,
1991: decode(sign(md.dmd_satisfied_date - md.using_assembly_demand_date),

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

1991: decode(sign(md.dmd_satisfied_date - md.using_assembly_demand_date),
1992: 1, GREATEST(round(md.dmd_satisfied_date -
1993: md.using_assembly_demand_date,2), 0.01), 0) days_late,
1994: nvl(to_char(md.quantity_by_due_date),'null') qty_by_due_date,
1995: msc_get_name.org_code(md.organization_id, md.sr_instance_id) org,
1996: nvl(md.demand_class,'null') demand_class
1997: FROM msc_demands md
1998: WHERE md.plan_id = p_plan_id
1999: AND md.demand_id = v_demand_id

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

2148: FIRM_START_RES,
2149: mrr.firm_start_date + (mrr.end_date - mrr.start_date),
2150: nvl(mrr.firm_end_date, mrr.end_date))),
2151: format_mask) end_date,
2152: nvl(msc_get_name.job_name(mrr.supply_id, p_plan_id),
2153: to_char(mrr.supply_id)) job_name,
2154: msc_get_name.supply_type(mrr.supply_id, mrr.plan_id) supply_type,
2155: mrr.assigned_units,
2156: mrr.transaction_id,

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

2150: nvl(mrr.firm_end_date, mrr.end_date))),
2151: format_mask) end_date,
2152: nvl(msc_get_name.job_name(mrr.supply_id, p_plan_id),
2153: to_char(mrr.supply_id)) job_name,
2154: msc_get_name.supply_type(mrr.supply_id, mrr.plan_id) supply_type,
2155: mrr.assigned_units,
2156: mrr.transaction_id,
2157: mrr.sr_instance_id
2158: from msc_resource_requirements mrr

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

2246: FIRM_START_RES,
2247: mrr.firm_start_date + (mrr.end_date - mrr.start_date),
2248: nvl(mrr.firm_end_date, mrr.end_date))),
2249: format_mask) end_date,
2250: nvl(msc_get_name.job_name(mrr.supply_id, p_plan_id),
2251: to_char(mrr.supply_id)) job_name,
2252: msc_get_name.supply_type(mrr.supply_id, mrr.plan_id) supply_type,
2253: mrr.assigned_units,
2254: mrr.transaction_id,

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

2248: nvl(mrr.firm_end_date, mrr.end_date))),
2249: format_mask) end_date,
2250: nvl(msc_get_name.job_name(mrr.supply_id, p_plan_id),
2251: to_char(mrr.supply_id)) job_name,
2252: msc_get_name.supply_type(mrr.supply_id, mrr.plan_id) supply_type,
2253: mrr.assigned_units,
2254: mrr.transaction_id,
2255: mrr.sr_instance_id
2256: from msc_resource_requirements mrr

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

3874:
3875: CURSOR ops_data_cursor IS
3876: select to_char(mrr.operation_seq_num)||'/'
3877: ||to_char(mrr.resource_seq_num)||
3878: '('||msc_get_name.department_resource_code(mrr.resource_id,
3879: mrr.department_id, mrr.organization_id,
3880: mrr.plan_id, mrr.sr_instance_id)||')',
3881: to_char(msc_get_gantt_data.get_start_date(
3882: mrr.plan_id, mrr.transaction_id, mrr.sr_instance_id),

Line 5095: SELECT msc_get_name.item_name(ms.inventory_item_id,null,null,null) item,

5091: v_pro out NOCOPY varchar2, v_demand out NOCOPY varchar2)
5092: IS
5093:
5094: CURSOR job_cur IS
5095: SELECT msc_get_name.item_name(ms.inventory_item_id,null,null,null) item,
5096: ms.new_order_quantity qty,
5097: nvl(to_char(ms.firm_date,format_mask), ' ') firm_date,
5098: to_char(ms.new_schedule_date,format_mask) sugg_due_date,
5099: nvl(to_char(ms.need_by_date,format_mask), ' ') needby,

Line 5101: nvl(msc_get_name.project(ms.project_id,

5097: nvl(to_char(ms.firm_date,format_mask), ' ') firm_date,
5098: to_char(ms.new_schedule_date,format_mask) sugg_due_date,
5099: nvl(to_char(ms.need_by_date,format_mask), ' ') needby,
5100: nvl(ms.unit_number,'null') unit_number,
5101: nvl(msc_get_name.project(ms.project_id,
5102: ms.organization_id,
5103: ms.plan_id,
5104: ms.sr_instance_id), 'null') project,
5105: nvl(msc_get_name.task( ms.task_id,

Line 5105: nvl(msc_get_name.task( ms.task_id,

5101: nvl(msc_get_name.project(ms.project_id,
5102: ms.organization_id,
5103: ms.plan_id,
5104: ms.sr_instance_id), 'null') project,
5105: nvl(msc_get_name.task( ms.task_id,
5106: ms.project_id,
5107: ms.organization_id,
5108: ms.plan_id,
5109: ms.sr_instance_id),'null') task,

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

5106: ms.project_id,
5107: ms.organization_id,
5108: ms.plan_id,
5109: ms.sr_instance_id),'null') task,
5110: msc_get_name.org_code(ms.organization_id, ms.sr_instance_id) org,
5111: msc_get_gantt_data.order_number(ms.order_type,ms.order_number,
5112: ms.plan_id, ms.sr_instance_id,
5113: ms.transaction_id, ms.disposition_id) job_name,
5114: ms.firm_planned_type,

Line 5120: msc_get_name.supply_type(ms.transaction_id, p_plan_id) supply_type,

5116: nvl(ms.alternate_routing_designator, 'null')
5117: alternate_routing_designator,
5118: ms.organization_id org_id,
5119: nvl(to_char(msi.planning_time_fence_date, format_mask),' ') time_fence,
5120: msc_get_name.supply_type(ms.transaction_id, p_plan_id) supply_type,
5121: decode(msc_get_gantt_data.supplyType(ms.order_type,
5122: msi.planning_make_buy_code,
5123: ms.organization_id,
5124: ms.source_organization_id),

Line 5129: nvl(msc_get_name.supplier(

5125: BUY_SUPPLY, g_buy_text,
5126: TRANSFER_SUPPLY, g_transfer_text,
5127: MAKE_SUPPLY, g_make_text) item_type,
5128: msi.description,
5129: nvl(msc_get_name.supplier(
5130: nvl(ms.source_supplier_id, ms.supplier_id)),'-1') supplier,
5131: nvl(msc_get_name.org_code(ms.source_organization_id,
5132: ms.source_sr_instance_id),'-1') source_org,
5133: nvl(ms.ship_method, '-1') ship_method,

Line 5131: nvl(msc_get_name.org_code(ms.source_organization_id,

5127: MAKE_SUPPLY, g_make_text) item_type,
5128: msi.description,
5129: nvl(msc_get_name.supplier(
5130: nvl(ms.source_supplier_id, ms.supplier_id)),'-1') supplier,
5131: nvl(msc_get_name.org_code(ms.source_organization_id,
5132: ms.source_sr_instance_id),'-1') source_org,
5133: nvl(ms.ship_method, '-1') ship_method,
5134: msc_get_name.lookup_meaning('SYS_YES_NO',
5135: decode(ms.supply_is_shared,1,1,2)) share_supply,

Line 5134: msc_get_name.lookup_meaning('SYS_YES_NO',

5130: nvl(ms.source_supplier_id, ms.supplier_id)),'-1') supplier,
5131: nvl(msc_get_name.org_code(ms.source_organization_id,
5132: ms.source_sr_instance_id),'-1') source_org,
5133: nvl(ms.ship_method, '-1') ship_method,
5134: msc_get_name.lookup_meaning('SYS_YES_NO',
5135: decode(ms.supply_is_shared,1,1,2)) share_supply,
5136: nvl(to_char(ms.EARLIEST_START_DATE,format_mask),'null') EPSD,
5137: nvl(to_char(ms.EARLIEST_COMPLETION_DATE,format_mask),'null') EPCD,
5138: nvl(to_char(ms.UEPSD,format_mask),'null') UEPSD,

Line 5153: SELECT msc_get_name.item_name(mrr.assembly_item_id,null,null,null) item,

5149: and msi.sr_instance_id = ms.sr_instance_id
5150: and msi.inventory_item_id = ms.inventory_item_id;
5151:
5152: CURSOR res_cur IS
5153: SELECT msc_get_name.item_name(mrr.assembly_item_id,null,null,null) item,
5154: nvl(mrr.operation_seq_num,0) op_seq,
5155: msc_get_name.org_code(mrr.organization_id, mrr.sr_instance_id) org,
5156: msc_get_name.department_code(decode(mrr.resource_id, -1, 1,2),
5157: mrr.department_id, mrr.organization_id,

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

5151:
5152: CURSOR res_cur IS
5153: SELECT msc_get_name.item_name(mrr.assembly_item_id,null,null,null) item,
5154: nvl(mrr.operation_seq_num,0) op_seq,
5155: msc_get_name.org_code(mrr.organization_id, mrr.sr_instance_id) org,
5156: msc_get_name.department_code(decode(mrr.resource_id, -1, 1,2),
5157: mrr.department_id, mrr.organization_id,
5158: mrr.plan_id, mrr.sr_instance_id) dept_code,
5159: nvl(msc_get_name.job_name(mrr.supply_id, p_plan_id),

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

5152: CURSOR res_cur IS
5153: SELECT msc_get_name.item_name(mrr.assembly_item_id,null,null,null) item,
5154: nvl(mrr.operation_seq_num,0) op_seq,
5155: msc_get_name.org_code(mrr.organization_id, mrr.sr_instance_id) org,
5156: msc_get_name.department_code(decode(mrr.resource_id, -1, 1,2),
5157: mrr.department_id, mrr.organization_id,
5158: mrr.plan_id, mrr.sr_instance_id) dept_code,
5159: nvl(msc_get_name.job_name(mrr.supply_id, p_plan_id),
5160: to_char(mrr.supply_id)) job_name,

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

5155: msc_get_name.org_code(mrr.organization_id, mrr.sr_instance_id) org,
5156: msc_get_name.department_code(decode(mrr.resource_id, -1, 1,2),
5157: mrr.department_id, mrr.organization_id,
5158: mrr.plan_id, mrr.sr_instance_id) dept_code,
5159: nvl(msc_get_name.job_name(mrr.supply_id, p_plan_id),
5160: to_char(mrr.supply_id)) job_name,
5161: nvl(mrr.assigned_units,0) assigned_units,
5162: msc_get_name.lookup_meaning('RESOURCE_FIRM_TYPE',
5163: nvl(mrr.firm_flag,0)) firm_flag,

Line 5162: msc_get_name.lookup_meaning('RESOURCE_FIRM_TYPE',

5158: mrr.plan_id, mrr.sr_instance_id) dept_code,
5159: nvl(msc_get_name.job_name(mrr.supply_id, p_plan_id),
5160: to_char(mrr.supply_id)) job_name,
5161: nvl(mrr.assigned_units,0) assigned_units,
5162: msc_get_name.lookup_meaning('RESOURCE_FIRM_TYPE',
5163: nvl(mrr.firm_flag,0)) firm_flag,
5164: nvl(mrr.alternate_num,0) alternate_num,
5165: nvl(mrr.resource_seq_num,0) res_seq_num,
5166: nvl(msc_get_name.resource_code(mrr.resource_id,

Line 5166: nvl(msc_get_name.resource_code(mrr.resource_id,

5162: msc_get_name.lookup_meaning('RESOURCE_FIRM_TYPE',
5163: nvl(mrr.firm_flag,0)) firm_flag,
5164: nvl(mrr.alternate_num,0) alternate_num,
5165: nvl(mrr.resource_seq_num,0) res_seq_num,
5166: nvl(msc_get_name.resource_code(mrr.resource_id,
5167: mrr.department_id, mrr.organization_id,
5168: mrr.plan_id, mrr.sr_instance_id)
5169: , 'null') res_code,
5170: nvl(mrr.resource_hours,0) resource_hours,

Line 5178: msc_get_name.lookup_meaning(

5174: nvl(mdr.batchable_flag,2) batchable,
5175: nvl(mrr.batch_number, -1) batch_number,
5176: nvl(mdr.unit_of_measure,'-1') uom,
5177: nvl(decode(mrr.basis_type, null, '-1',
5178: msc_get_name.lookup_meaning(
5179: 'MSC_RES_BASIS_TYPE',mrr.basis_type)),'-1') basis_type,
5180: nvl(decode(mrr.schedule_flag, null, '-1',
5181: msc_get_name.lookup_meaning(
5182: 'BOM_RESOURCE_SCHEDULE_TYPE',mrr.schedule_flag)),'-1') schedule_flag,

Line 5181: msc_get_name.lookup_meaning(

5177: nvl(decode(mrr.basis_type, null, '-1',
5178: msc_get_name.lookup_meaning(
5179: 'MSC_RES_BASIS_TYPE',mrr.basis_type)),'-1') basis_type,
5180: nvl(decode(mrr.schedule_flag, null, '-1',
5181: msc_get_name.lookup_meaning(
5182: 'BOM_RESOURCE_SCHEDULE_TYPE',mrr.schedule_flag)),'-1') schedule_flag,
5183: nvl(to_char(mrr.EARLIEST_START_DATE,format_mask),'null') EPSD,
5184: nvl(to_char(mrr.EARLIEST_COMPLETION_DATE,format_mask),'null') EPCD,
5185: nvl(to_char(mrr.UEPSD,format_mask),'null') UEPSD,

Line 5728: nvl(msc_get_name.designator(md.schedule_designator_id),

5724: CURSOR end_demand_cur IS
5725: select md.organization_id,
5726: md.demand_id, md.sr_instance_id,
5727: nvl(md.order_number,
5728: nvl(msc_get_name.designator(md.schedule_designator_id),
5729: md.demand_id)) ||' for '||
5730: mi.item_name ||
5731: ' in ' || mtp.organization_code ||'('||
5732: md.using_requirement_quantity||')',

Line 6033: msc_get_name.designator(md.schedule_designator_id))

6029: rowCount := 0;
6030: select distinct
6031: md.demand_id,
6032: nvl(md.order_number,
6033: msc_get_name.designator(md.schedule_designator_id))
6034: ||'('||md.using_assembly_demand_date||','||
6035: md.USING_REQUIREMENT_QUANTITY||')' ,
6036: md.using_assembly_demand_date
6037: bulk collect into v_demand_id, v_order_name , v_dummy_date