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 60: TYPE excepRecTyp IS RECORD ( exception_id msc_exception_details_v.exception_id%type,

56:
57: TYPE excepTyp IS REF CURSOR;
58: c_exceptions excepTyp;
59:
60: TYPE excepRecTyp IS RECORD ( exception_id msc_exception_details_v.exception_id%type,
61: sr_instance_Id msc_exception_details_v.sr_instance_Id%type,
62: organization_id msc_exception_details_v.organization_id%type,
63: inventory_item_id msc_exception_details_v.inventory_item_id%type,
64: supplier_id msc_exception_details_v.supplier_id%type,

Line 61: sr_instance_Id msc_exception_details_v.sr_instance_Id%type,

57: TYPE excepTyp IS REF CURSOR;
58: c_exceptions excepTyp;
59:
60: TYPE excepRecTyp IS RECORD ( exception_id msc_exception_details_v.exception_id%type,
61: sr_instance_Id msc_exception_details_v.sr_instance_Id%type,
62: organization_id msc_exception_details_v.organization_id%type,
63: inventory_item_id msc_exception_details_v.inventory_item_id%type,
64: supplier_id msc_exception_details_v.supplier_id%type,
65: supplier_site_id msc_exception_details_v.supplier_site_id%type,

Line 62: organization_id msc_exception_details_v.organization_id%type,

58: c_exceptions excepTyp;
59:
60: TYPE excepRecTyp IS RECORD ( exception_id msc_exception_details_v.exception_id%type,
61: sr_instance_Id msc_exception_details_v.sr_instance_Id%type,
62: organization_id msc_exception_details_v.organization_id%type,
63: inventory_item_id msc_exception_details_v.inventory_item_id%type,
64: supplier_id msc_exception_details_v.supplier_id%type,
65: supplier_site_id msc_exception_details_v.supplier_site_id%type,
66: transaction_id msc_exception_details_v.transaction_id%type,

Line 63: inventory_item_id msc_exception_details_v.inventory_item_id%type,

59:
60: TYPE excepRecTyp IS RECORD ( exception_id msc_exception_details_v.exception_id%type,
61: sr_instance_Id msc_exception_details_v.sr_instance_Id%type,
62: organization_id msc_exception_details_v.organization_id%type,
63: inventory_item_id msc_exception_details_v.inventory_item_id%type,
64: supplier_id msc_exception_details_v.supplier_id%type,
65: supplier_site_id msc_exception_details_v.supplier_site_id%type,
66: transaction_id msc_exception_details_v.transaction_id%type,
67: demand_id msc_exception_details_v.demand_id%type,

Line 64: supplier_id msc_exception_details_v.supplier_id%type,

60: TYPE excepRecTyp IS RECORD ( exception_id msc_exception_details_v.exception_id%type,
61: sr_instance_Id msc_exception_details_v.sr_instance_Id%type,
62: organization_id msc_exception_details_v.organization_id%type,
63: inventory_item_id msc_exception_details_v.inventory_item_id%type,
64: supplier_id msc_exception_details_v.supplier_id%type,
65: supplier_site_id msc_exception_details_v.supplier_site_id%type,
66: transaction_id msc_exception_details_v.transaction_id%type,
67: demand_id msc_exception_details_v.demand_id%type,
68: exception_type msc_exception_details_v.exception_type%type,

Line 65: supplier_site_id msc_exception_details_v.supplier_site_id%type,

61: sr_instance_Id msc_exception_details_v.sr_instance_Id%type,
62: organization_id msc_exception_details_v.organization_id%type,
63: inventory_item_id msc_exception_details_v.inventory_item_id%type,
64: supplier_id msc_exception_details_v.supplier_id%type,
65: supplier_site_id msc_exception_details_v.supplier_site_id%type,
66: transaction_id msc_exception_details_v.transaction_id%type,
67: demand_id msc_exception_details_v.demand_id%type,
68: exception_type msc_exception_details_v.exception_type%type,
69: from_date msc_exception_details_v.from_date%type,

Line 66: transaction_id msc_exception_details_v.transaction_id%type,

62: organization_id msc_exception_details_v.organization_id%type,
63: inventory_item_id msc_exception_details_v.inventory_item_id%type,
64: supplier_id msc_exception_details_v.supplier_id%type,
65: supplier_site_id msc_exception_details_v.supplier_site_id%type,
66: transaction_id msc_exception_details_v.transaction_id%type,
67: demand_id msc_exception_details_v.demand_id%type,
68: exception_type msc_exception_details_v.exception_type%type,
69: from_date msc_exception_details_v.from_date%type,
70: to_date msc_exception_details_v.to_date%type,

Line 67: demand_id msc_exception_details_v.demand_id%type,

63: inventory_item_id msc_exception_details_v.inventory_item_id%type,
64: supplier_id msc_exception_details_v.supplier_id%type,
65: supplier_site_id msc_exception_details_v.supplier_site_id%type,
66: transaction_id msc_exception_details_v.transaction_id%type,
67: demand_id msc_exception_details_v.demand_id%type,
68: exception_type msc_exception_details_v.exception_type%type,
69: from_date msc_exception_details_v.from_date%type,
70: to_date msc_exception_details_v.to_date%type,
71: budget_violation_date msc_exception_details_v.budget_violation_date%type,

Line 68: exception_type msc_exception_details_v.exception_type%type,

64: supplier_id msc_exception_details_v.supplier_id%type,
65: supplier_site_id msc_exception_details_v.supplier_site_id%type,
66: transaction_id msc_exception_details_v.transaction_id%type,
67: demand_id msc_exception_details_v.demand_id%type,
68: exception_type msc_exception_details_v.exception_type%type,
69: from_date msc_exception_details_v.from_date%type,
70: to_date msc_exception_details_v.to_date%type,
71: budget_violation_date msc_exception_details_v.budget_violation_date%type,
72: department_id msc_exception_details_v.department_id%type,

Line 69: from_date msc_exception_details_v.from_date%type,

65: supplier_site_id msc_exception_details_v.supplier_site_id%type,
66: transaction_id msc_exception_details_v.transaction_id%type,
67: demand_id msc_exception_details_v.demand_id%type,
68: exception_type msc_exception_details_v.exception_type%type,
69: from_date msc_exception_details_v.from_date%type,
70: to_date msc_exception_details_v.to_date%type,
71: budget_violation_date msc_exception_details_v.budget_violation_date%type,
72: department_id msc_exception_details_v.department_id%type,
73: resource_id msc_exception_details_v.resource_id%type,

Line 70: to_date msc_exception_details_v.to_date%type,

66: transaction_id msc_exception_details_v.transaction_id%type,
67: demand_id msc_exception_details_v.demand_id%type,
68: exception_type msc_exception_details_v.exception_type%type,
69: from_date msc_exception_details_v.from_date%type,
70: to_date msc_exception_details_v.to_date%type,
71: budget_violation_date msc_exception_details_v.budget_violation_date%type,
72: department_id msc_exception_details_v.department_id%type,
73: resource_id msc_exception_details_v.resource_id%type,
74: end_pegging_id msc_exception_details_v.end_pegging_id%type,

Line 71: budget_violation_date msc_exception_details_v.budget_violation_date%type,

67: demand_id msc_exception_details_v.demand_id%type,
68: exception_type msc_exception_details_v.exception_type%type,
69: from_date msc_exception_details_v.from_date%type,
70: to_date msc_exception_details_v.to_date%type,
71: budget_violation_date msc_exception_details_v.budget_violation_date%type,
72: department_id msc_exception_details_v.department_id%type,
73: resource_id msc_exception_details_v.resource_id%type,
74: end_pegging_id msc_exception_details_v.end_pegging_id%type,
75: operation_seq_num msc_exception_details_v.operation_seq_num%type,

Line 72: department_id msc_exception_details_v.department_id%type,

68: exception_type msc_exception_details_v.exception_type%type,
69: from_date msc_exception_details_v.from_date%type,
70: to_date msc_exception_details_v.to_date%type,
71: budget_violation_date msc_exception_details_v.budget_violation_date%type,
72: department_id msc_exception_details_v.department_id%type,
73: resource_id msc_exception_details_v.resource_id%type,
74: end_pegging_id msc_exception_details_v.end_pegging_id%type,
75: operation_seq_num msc_exception_details_v.operation_seq_num%type,
76: resource_seq_num msc_exception_details_v.resource_seq_num%type);

Line 73: resource_id msc_exception_details_v.resource_id%type,

69: from_date msc_exception_details_v.from_date%type,
70: to_date msc_exception_details_v.to_date%type,
71: budget_violation_date msc_exception_details_v.budget_violation_date%type,
72: department_id msc_exception_details_v.department_id%type,
73: resource_id msc_exception_details_v.resource_id%type,
74: end_pegging_id msc_exception_details_v.end_pegging_id%type,
75: operation_seq_num msc_exception_details_v.operation_seq_num%type,
76: resource_seq_num msc_exception_details_v.resource_seq_num%type);
77: rec_exceptions excepRecTyp;

Line 74: end_pegging_id msc_exception_details_v.end_pegging_id%type,

70: to_date msc_exception_details_v.to_date%type,
71: budget_violation_date msc_exception_details_v.budget_violation_date%type,
72: department_id msc_exception_details_v.department_id%type,
73: resource_id msc_exception_details_v.resource_id%type,
74: end_pegging_id msc_exception_details_v.end_pegging_id%type,
75: operation_seq_num msc_exception_details_v.operation_seq_num%type,
76: resource_seq_num msc_exception_details_v.resource_seq_num%type);
77: rec_exceptions excepRecTyp;
78: TYPE numList IS TABLE Of NUMBER Index By BINARY_INTEGER;

Line 75: operation_seq_num msc_exception_details_v.operation_seq_num%type,

71: budget_violation_date msc_exception_details_v.budget_violation_date%type,
72: department_id msc_exception_details_v.department_id%type,
73: resource_id msc_exception_details_v.resource_id%type,
74: end_pegging_id msc_exception_details_v.end_pegging_id%type,
75: operation_seq_num msc_exception_details_v.operation_seq_num%type,
76: resource_seq_num msc_exception_details_v.resource_seq_num%type);
77: rec_exceptions excepRecTyp;
78: TYPE numList IS TABLE Of NUMBER Index By BINARY_INTEGER;
79: l_list numList;

Line 76: resource_seq_num msc_exception_details_v.resource_seq_num%type);

72: department_id msc_exception_details_v.department_id%type,
73: resource_id msc_exception_details_v.resource_id%type,
74: end_pegging_id msc_exception_details_v.end_pegging_id%type,
75: operation_seq_num msc_exception_details_v.operation_seq_num%type,
76: resource_seq_num msc_exception_details_v.resource_seq_num%type);
77: rec_exceptions excepRecTyp;
78: TYPE numList IS TABLE Of NUMBER Index By BINARY_INTEGER;
79: l_list numList;
80: l_item_list numList;

Line 463: ' FROM msc_exception_details_v med '||

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

Line 1627: ' FROM MSC_EXCEPTION_DETAILS_V med ';*/

1623: /*v_excp_str := ' SELECT DISTINCT '||p_query_id||', '||p_obj_sequence_id||', '||p_sequence_id ||
1624: ', med.TRANSACTION_ID, med.INVENTORY_ITEM_ID ' ||
1625: ', med.SR_INSTANCE_ID,med.ORGANIZATION_ID ' ||
1626: ', SYSDATE, fnd_global.user_id,SYSDATE, fnd_global.user_id, fnd_global.login_id'||
1627: ' FROM MSC_EXCEPTION_DETAILS_V med ';*/
1628: /*v_excp_str := ' SELECT DISTINCT '||p_query_id||', '||p_obj_sequence_id||', '||p_sequence_id ||
1629: ', med.TRANSACTION_ID, med.INVENTORY_ITEM_ID ' ||
1630: ', SYSDATE, fnd_global.user_id,SYSDATE, fnd_global.user_id, fnd_global.login_id'||
1631: ' FROM MSC_EXCEPTION_DETAILS_V med ';*/

Line 1631: ' FROM MSC_EXCEPTION_DETAILS_V med ';*/

1627: ' FROM MSC_EXCEPTION_DETAILS_V med ';*/
1628: /*v_excp_str := ' SELECT DISTINCT '||p_query_id||', '||p_obj_sequence_id||', '||p_sequence_id ||
1629: ', med.TRANSACTION_ID, med.INVENTORY_ITEM_ID ' ||
1630: ', SYSDATE, fnd_global.user_id,SYSDATE, fnd_global.user_id, fnd_global.login_id'||
1631: ' FROM MSC_EXCEPTION_DETAILS_V med ';*/
1632: /*v_excp_where := ' WHERE med.plan_id = '||p_plan_id ||
1633: ' AND NVL(med.category_set_id,2) = 2' ||
1634: ' AND ( med.ORDER_NUMBER IS NOT NULL '||
1635: ' OR med.INVENTORY_ITEM_ID IS NOT NULL)';*/