APPS.INV_MMX_WRAPPER_PVT dependencies on PO_LOCATION_ASSOCIATIONS_ALL

Line 536: -- MOAC : change from PO_LOCATION_ASSOCIATIONS table to PO_LOCATION_ASSOCIATIONS_ALL

532: --
533: -- Get the customer Id.
534: --
535:
536: -- MOAC : change from PO_LOCATION_ASSOCIATIONS table to PO_LOCATION_ASSOCIATIONS_ALL
537: --Bug :4968383 Added condition org_id=l_operating_unit to fetch the customer details
538: -- of the CURRENT operating unit in which the Min-Max report is requested.
539:
540: BEGIN

Line 543: FROM PO_LOCATION_ASSOCIATIONS_ALL

539:
540: BEGIN
541: SELECT CUSTOMER_ID,SITE_USE_ID
542: INTO l_cust_id,l_site_use_id
543: FROM PO_LOCATION_ASSOCIATIONS_ALL
544: WHERE LOCATION_ID = l_dd_loc_id
545: AND org_id=l_operating_unit;
546:
547: EXCEPTION