APPS.MRP_EXP_WF dependencies on MRP_EXCEPTION_DETAILS_V

Line 35: FROM mrp_exception_details_v exp, mrp_plan_organizations_v mpo

31: exp.end_order_number,
32: exp.department_line_code,
33: exp.resource_code,
34: exp.utilization_rate
35: FROM mrp_exception_details_v exp, mrp_plan_organizations_v mpo
36: WHERE exp.exception_type in (1,2,3,6,7,8,9,10,12,13,14,15,16,17,18,19,20)
37: AND mpo.organization_id = p_owning_org_id
38: AND mpo.compile_designator = p_designator
39: AND exp.organization_id = mpo.planned_organization

Line 48: mrp_exception_details_v exp

44: SELECT vend.vendor_id,
45: vend.vendor_name
46: FROM po_vendors vend,
47: mrp_recommendations rec,
48: mrp_exception_details_v exp
49: WHERE vend.vendor_id = rec.vendor_id
50: AND rec.transaction_id = exp.transaction_id
51: AND exp.exception_id = p_exception_id;
52:

Line 63: mrp_exception_details_v exp

59: po_headers_all poh,
60: po_vendors vend,
61: mrp_item_purchase_orders ipo,
62: mrp_recommendations rec,
63: mrp_exception_details_v exp
64: WHERE site.vendor_site_id = poh.vendor_site_id
65: AND site.org_id = poh.org_id
66: AND poh.po_header_id = ipo.purchase_order_id
67: AND ipo.transaction_id = rec.disposition_id

Line 82: mrp_exception_details_v exp

78: oe_order_types_v sot,
79: mtl_sales_orders mso,
80: mrp_schedule_dates dates,
81: mrp_gross_requirements mgr,
82: mrp_exception_details_v exp
83: WHERE cust.cust_account_id = soh.sold_to_org_id
84: AND soh.order_number = to_number(mso.segment1)
85: AND soh.order_type_id = sot.order_type_id
86: AND sot.name = mso.segment2

Line 202: mrp_exception_details_v exp

198:
199: SELECT rec.order_type
200: INTO l_order_type_code
201: FROM mrp_recommendations rec,
202: mrp_exception_details_v exp
203: WHERE rec.transaction_id = exp.transaction_id
204: AND exp.exception_id = l_exception_id;
205:
206: -- Purchase Order

Line 1027: mrp_exception_details_v exp

1023: oe_order_types_v sot,
1024: mtl_sales_orders mso,
1025: mrp_schedule_dates dates,
1026: mrp_gross_requirements mgr,
1027: mrp_exception_details_v exp
1028: WHERE
1029: rep.org_id = soh.org_id
1030: AND rep.salesrep_id = soh.salesrep_id
1031: AND soh.order_number = to_number(mso.segment1)

Line 1734: FROM mrp_exception_details_v

1730: FROM dual;
1731:
1732: SELECT transaction_id
1733: INTO l_transaction_id
1734: FROM mrp_exception_details_v
1735: WHERE exception_id = l_exception_id;
1736:
1737: if (l_order_type in (3, 13)) then
1738:

Line 1973: -- mrp_exception_details_v exp

1969: AND to_number(item_key) <= p_max_exception_id;
1970:
1971: -- SELECT wfi.item_key
1972: -- FROM wf_items wfi,
1973: -- mrp_exception_details_v exp
1974: -- WHERE wfi.item_key = to_char(exp.exception_id)
1975: -- AND wfi.item_type = 'MRPEXPWF'
1976: -- AND exp.exception_type in (1,2,3,6,7,8,9,10,12,13,14,15,16,17,18,19,20)
1977: -- AND exp.compile_designator = p_compile_desig