APPS.MSC_GET_NAME dependencies on MSC_X_EXCEPTION_DETAILS

Line 2494: msc_x_exception_details mxed

2490: 'DATE1',date1,'DATE2',date2,'DATE3',date3,'DATE4',date4,
2491: 'DATE5',date5,'DATE6',date6,'DATE7',date7)
2492: into l_date
2493: from msc_user_exception_components muec,
2494: msc_x_exception_details mxed
2495: where muec.exception_id = mxed.exception_type
2496: and mxed.exception_detail_id = arg_exception_id
2497: and muec.component_type = 1
2498: and muec.ak_attribute_code = 'MSCX_CUST_SHIP_DATE';

Line 2517: msc_x_exception_details mxed

2513: select decode(muec.exception_column, 'NUMBER1',NUMBER1,'NUMBER2',NUMBER2,
2514: 'NUMBER3',NUMBER3,'NUMBER4',NUMBER4,'NUMBER5',NUMBER5,'NUMBER6',NUMBER6,'NUMBER7',NUMBER7)
2515: into l_temp
2516: from msc_user_exception_components muec,
2517: msc_x_exception_details mxed
2518: where muec.exception_id = mxed.exception_type
2519: and mxed.exception_detail_id = arg_exception_id
2520: and muec.component_type = 1
2521: and muec.ak_attribute_code = 'MSCX_UDE_PUB_ORDER_TYPE';

Line 2543: msc_x_exception_details mxed

2539: 'USER_ATTRIBUTE5',USER_ATTRIBUTE5,'USER_ATTRIBUTE6',USER_ATTRIBUTE6,
2540: 'USER_ATTRIBUTE7',USER_ATTRIBUTE7)
2541: into l_temp
2542: from msc_user_exception_components muec,
2543: msc_x_exception_details mxed
2544: where muec.exception_id = mxed.exception_type
2545: and mxed.exception_detail_id = arg_exception_id
2546: and muec.component_type = 1
2547: and muec.ak_attribute_code = 'MSCX_PLANNER_CODE';

Line 2567: msc_x_exception_details mxed

2563: 'NUMBER3',NUMBER3,'NUMBER4',NUMBER4,'NUMBER5',NUMBER5,
2564: 'NUMBER6',NUMBER6,'NUMBER7',NUMBER7)
2565: into l_temp
2566: from msc_user_exception_components muec,
2567: msc_x_exception_details mxed
2568: where muec.exception_id = mxed.exception_type
2569: and mxed.exception_detail_id = arg_exception_id
2570: and muec.component_type = 1
2571: and muec.ak_attribute_code = 'MSCX_QUANTITY';

Line 2590: msc_x_exception_details mxed

2586: select decode(muec.exception_column, 'DATE1',date1,'DATE2',date2,'DATE3',date3,
2587: 'DATE4',date4,'DATE5',date5,'DATE6',date6,'DATE7',date7)
2588: into l_temp
2589: from msc_user_exception_components muec,
2590: msc_x_exception_details mxed
2591: where muec.exception_id = mxed.exception_type
2592: and mxed.exception_detail_id = arg_exception_id
2593: and muec.component_type = 1
2594: and muec.ak_attribute_code = 'MSCX_COMP_RECEIPT_DATE';

Line 2613: msc_x_exception_details mxed

2609: select decode(muec.exception_column, 'DATE1',date1,'DATE2',date2,'DATE3',date3,
2610: 'DATE4',date4,'DATE5',date5,'DATE6',date6,'DATE7',date7)
2611: into l_temp
2612: from msc_user_exception_components muec,
2613: msc_x_exception_details mxed
2614: where muec.exception_id = mxed.exception_type
2615: and muec.exception_id = arg_exception_id
2616: and mxed.exception_detail_id = arg_exception_id
2617: and muec.component_type = 1