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_PQ_UTILS dependencies on MSC_EXCEPTION_DETAILS_V

Line 56: TYPE excepRecTyp IS RECORD ( exception_id msc_exception_details_v.exception_id%type,

52:
53: TYPE excepTyp IS REF CURSOR;
54: c_exceptions excepTyp;
55:
56: TYPE excepRecTyp IS RECORD ( exception_id msc_exception_details_v.exception_id%type,
57: sr_instance_Id msc_exception_details_v.sr_instance_Id%type,
58: organization_id msc_exception_details_v.organization_id%type,
59: inventory_item_id msc_exception_details_v.inventory_item_id%type,
60: supplier_id msc_exception_details_v.supplier_id%type,

Line 57: sr_instance_Id msc_exception_details_v.sr_instance_Id%type,

53: TYPE excepTyp IS REF CURSOR;
54: c_exceptions excepTyp;
55:
56: TYPE excepRecTyp IS RECORD ( exception_id msc_exception_details_v.exception_id%type,
57: sr_instance_Id msc_exception_details_v.sr_instance_Id%type,
58: organization_id msc_exception_details_v.organization_id%type,
59: inventory_item_id msc_exception_details_v.inventory_item_id%type,
60: supplier_id msc_exception_details_v.supplier_id%type,
61: supplier_site_id msc_exception_details_v.supplier_site_id%type,

Line 58: organization_id msc_exception_details_v.organization_id%type,

54: c_exceptions excepTyp;
55:
56: TYPE excepRecTyp IS RECORD ( exception_id msc_exception_details_v.exception_id%type,
57: sr_instance_Id msc_exception_details_v.sr_instance_Id%type,
58: organization_id msc_exception_details_v.organization_id%type,
59: inventory_item_id msc_exception_details_v.inventory_item_id%type,
60: supplier_id msc_exception_details_v.supplier_id%type,
61: supplier_site_id msc_exception_details_v.supplier_site_id%type,
62: transaction_id msc_exception_details_v.transaction_id%type,

Line 59: inventory_item_id msc_exception_details_v.inventory_item_id%type,

55:
56: TYPE excepRecTyp IS RECORD ( exception_id msc_exception_details_v.exception_id%type,
57: sr_instance_Id msc_exception_details_v.sr_instance_Id%type,
58: organization_id msc_exception_details_v.organization_id%type,
59: inventory_item_id msc_exception_details_v.inventory_item_id%type,
60: supplier_id msc_exception_details_v.supplier_id%type,
61: supplier_site_id msc_exception_details_v.supplier_site_id%type,
62: transaction_id msc_exception_details_v.transaction_id%type,
63: demand_id msc_exception_details_v.demand_id%type,

Line 60: supplier_id msc_exception_details_v.supplier_id%type,

56: TYPE excepRecTyp IS RECORD ( exception_id msc_exception_details_v.exception_id%type,
57: sr_instance_Id msc_exception_details_v.sr_instance_Id%type,
58: organization_id msc_exception_details_v.organization_id%type,
59: inventory_item_id msc_exception_details_v.inventory_item_id%type,
60: supplier_id msc_exception_details_v.supplier_id%type,
61: supplier_site_id msc_exception_details_v.supplier_site_id%type,
62: transaction_id msc_exception_details_v.transaction_id%type,
63: demand_id msc_exception_details_v.demand_id%type,
64: exception_type msc_exception_details_v.exception_type%type,

Line 61: supplier_site_id msc_exception_details_v.supplier_site_id%type,

57: sr_instance_Id msc_exception_details_v.sr_instance_Id%type,
58: organization_id msc_exception_details_v.organization_id%type,
59: inventory_item_id msc_exception_details_v.inventory_item_id%type,
60: supplier_id msc_exception_details_v.supplier_id%type,
61: supplier_site_id msc_exception_details_v.supplier_site_id%type,
62: transaction_id msc_exception_details_v.transaction_id%type,
63: demand_id msc_exception_details_v.demand_id%type,
64: exception_type msc_exception_details_v.exception_type%type,
65: from_date msc_exception_details_v.from_date%type,

Line 62: transaction_id msc_exception_details_v.transaction_id%type,

58: organization_id msc_exception_details_v.organization_id%type,
59: inventory_item_id msc_exception_details_v.inventory_item_id%type,
60: supplier_id msc_exception_details_v.supplier_id%type,
61: supplier_site_id msc_exception_details_v.supplier_site_id%type,
62: transaction_id msc_exception_details_v.transaction_id%type,
63: demand_id msc_exception_details_v.demand_id%type,
64: exception_type msc_exception_details_v.exception_type%type,
65: from_date msc_exception_details_v.from_date%type,
66: to_date msc_exception_details_v.to_date%type,

Line 63: demand_id msc_exception_details_v.demand_id%type,

59: inventory_item_id msc_exception_details_v.inventory_item_id%type,
60: supplier_id msc_exception_details_v.supplier_id%type,
61: supplier_site_id msc_exception_details_v.supplier_site_id%type,
62: transaction_id msc_exception_details_v.transaction_id%type,
63: demand_id msc_exception_details_v.demand_id%type,
64: exception_type msc_exception_details_v.exception_type%type,
65: from_date msc_exception_details_v.from_date%type,
66: to_date msc_exception_details_v.to_date%type,
67: budget_violation_date msc_exception_details_v.budget_violation_date%type,

Line 64: exception_type msc_exception_details_v.exception_type%type,

60: supplier_id msc_exception_details_v.supplier_id%type,
61: supplier_site_id msc_exception_details_v.supplier_site_id%type,
62: transaction_id msc_exception_details_v.transaction_id%type,
63: demand_id msc_exception_details_v.demand_id%type,
64: exception_type msc_exception_details_v.exception_type%type,
65: from_date msc_exception_details_v.from_date%type,
66: to_date msc_exception_details_v.to_date%type,
67: budget_violation_date msc_exception_details_v.budget_violation_date%type,
68: department_id msc_exception_details_v.department_id%type,

Line 65: from_date msc_exception_details_v.from_date%type,

61: supplier_site_id msc_exception_details_v.supplier_site_id%type,
62: transaction_id msc_exception_details_v.transaction_id%type,
63: demand_id msc_exception_details_v.demand_id%type,
64: exception_type msc_exception_details_v.exception_type%type,
65: from_date msc_exception_details_v.from_date%type,
66: to_date msc_exception_details_v.to_date%type,
67: budget_violation_date msc_exception_details_v.budget_violation_date%type,
68: department_id msc_exception_details_v.department_id%type,
69: resource_id msc_exception_details_v.resource_id%type,

Line 66: to_date msc_exception_details_v.to_date%type,

62: transaction_id msc_exception_details_v.transaction_id%type,
63: demand_id msc_exception_details_v.demand_id%type,
64: exception_type msc_exception_details_v.exception_type%type,
65: from_date msc_exception_details_v.from_date%type,
66: to_date msc_exception_details_v.to_date%type,
67: budget_violation_date msc_exception_details_v.budget_violation_date%type,
68: department_id msc_exception_details_v.department_id%type,
69: resource_id msc_exception_details_v.resource_id%type,
70: end_pegging_id msc_exception_details_v.end_pegging_id%type,

Line 67: budget_violation_date msc_exception_details_v.budget_violation_date%type,

63: demand_id msc_exception_details_v.demand_id%type,
64: exception_type msc_exception_details_v.exception_type%type,
65: from_date msc_exception_details_v.from_date%type,
66: to_date msc_exception_details_v.to_date%type,
67: budget_violation_date msc_exception_details_v.budget_violation_date%type,
68: department_id msc_exception_details_v.department_id%type,
69: resource_id msc_exception_details_v.resource_id%type,
70: end_pegging_id msc_exception_details_v.end_pegging_id%type,
71: operation_seq_num msc_exception_details_v.operation_seq_num%type,

Line 68: department_id msc_exception_details_v.department_id%type,

64: exception_type msc_exception_details_v.exception_type%type,
65: from_date msc_exception_details_v.from_date%type,
66: to_date msc_exception_details_v.to_date%type,
67: budget_violation_date msc_exception_details_v.budget_violation_date%type,
68: department_id msc_exception_details_v.department_id%type,
69: resource_id msc_exception_details_v.resource_id%type,
70: end_pegging_id msc_exception_details_v.end_pegging_id%type,
71: operation_seq_num msc_exception_details_v.operation_seq_num%type,
72: resource_seq_num msc_exception_details_v.resource_seq_num%type);

Line 69: resource_id msc_exception_details_v.resource_id%type,

65: from_date msc_exception_details_v.from_date%type,
66: to_date msc_exception_details_v.to_date%type,
67: budget_violation_date msc_exception_details_v.budget_violation_date%type,
68: department_id msc_exception_details_v.department_id%type,
69: resource_id msc_exception_details_v.resource_id%type,
70: end_pegging_id msc_exception_details_v.end_pegging_id%type,
71: operation_seq_num msc_exception_details_v.operation_seq_num%type,
72: resource_seq_num msc_exception_details_v.resource_seq_num%type);
73: rec_exceptions excepRecTyp;

Line 70: end_pegging_id msc_exception_details_v.end_pegging_id%type,

66: to_date msc_exception_details_v.to_date%type,
67: budget_violation_date msc_exception_details_v.budget_violation_date%type,
68: department_id msc_exception_details_v.department_id%type,
69: resource_id msc_exception_details_v.resource_id%type,
70: end_pegging_id msc_exception_details_v.end_pegging_id%type,
71: operation_seq_num msc_exception_details_v.operation_seq_num%type,
72: resource_seq_num msc_exception_details_v.resource_seq_num%type);
73: rec_exceptions excepRecTyp;
74: TYPE numList IS TABLE Of NUMBER Index By BINARY_INTEGER;

Line 71: operation_seq_num msc_exception_details_v.operation_seq_num%type,

67: budget_violation_date msc_exception_details_v.budget_violation_date%type,
68: department_id msc_exception_details_v.department_id%type,
69: resource_id msc_exception_details_v.resource_id%type,
70: end_pegging_id msc_exception_details_v.end_pegging_id%type,
71: operation_seq_num msc_exception_details_v.operation_seq_num%type,
72: resource_seq_num msc_exception_details_v.resource_seq_num%type);
73: rec_exceptions excepRecTyp;
74: TYPE numList IS TABLE Of NUMBER Index By BINARY_INTEGER;
75: l_list numList;

Line 72: resource_seq_num msc_exception_details_v.resource_seq_num%type);

68: department_id msc_exception_details_v.department_id%type,
69: resource_id msc_exception_details_v.resource_id%type,
70: end_pegging_id msc_exception_details_v.end_pegging_id%type,
71: operation_seq_num msc_exception_details_v.operation_seq_num%type,
72: resource_seq_num msc_exception_details_v.resource_seq_num%type);
73: rec_exceptions excepRecTyp;
74: TYPE numList IS TABLE Of NUMBER Index By BINARY_INTEGER;
75: l_list numList;
76: l_item_list numList;

Line 459: ' FROM msc_exception_details_v med '||

455: ' transaction_id , demand_id , exception_type, '||
456: ' from_date , to_date, budget_violation_date, '||
457: ' department_id , resource_id, end_pegging_id, '||
458: ' operation_seq_num, resource_seq_num '||
459: ' FROM msc_exception_details_v med '||
460: ' WHERE med.plan_id = :plan_id '||
461: ' AND nvl(med.category_set_id,2) = :category_set_id ';
462:
463: l_sql_stmt := l_sql_stmt ||' AND '|| p_where_clause;

Line 1599: ' FROM MSC_EXCEPTION_DETAILS_V med ';*/

1595: /*v_excp_str := ' SELECT DISTINCT '||p_query_id||', '||p_obj_sequence_id||', '||p_sequence_id ||
1596: ', med.TRANSACTION_ID, med.INVENTORY_ITEM_ID ' ||
1597: ', med.SR_INSTANCE_ID,med.ORGANIZATION_ID ' ||
1598: ', SYSDATE, fnd_global.user_id,SYSDATE, fnd_global.user_id, fnd_global.login_id'||
1599: ' FROM MSC_EXCEPTION_DETAILS_V med ';*/
1600: /*v_excp_str := ' SELECT DISTINCT '||p_query_id||', '||p_obj_sequence_id||', '||p_sequence_id ||
1601: ', med.TRANSACTION_ID, med.INVENTORY_ITEM_ID ' ||
1602: ', SYSDATE, fnd_global.user_id,SYSDATE, fnd_global.user_id, fnd_global.login_id'||
1603: ' FROM MSC_EXCEPTION_DETAILS_V med ';*/

Line 1603: ' FROM MSC_EXCEPTION_DETAILS_V med ';*/

1599: ' FROM MSC_EXCEPTION_DETAILS_V med ';*/
1600: /*v_excp_str := ' SELECT DISTINCT '||p_query_id||', '||p_obj_sequence_id||', '||p_sequence_id ||
1601: ', med.TRANSACTION_ID, med.INVENTORY_ITEM_ID ' ||
1602: ', SYSDATE, fnd_global.user_id,SYSDATE, fnd_global.user_id, fnd_global.login_id'||
1603: ' FROM MSC_EXCEPTION_DETAILS_V med ';*/
1604: /*v_excp_where := ' WHERE med.plan_id = '||p_plan_id ||
1605: ' AND NVL(med.category_set_id,2) = 2' ||
1606: ' AND ( med.ORDER_NUMBER IS NOT NULL '||
1607: ' OR med.INVENTORY_ITEM_ID IS NOT NULL)';*/