APPS.INV_MMX_WRAPPER_PVT dependencies on PO_LOCATION_ASSOCIATIONS_ALL

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

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

Line 547: FROM PO_LOCATION_ASSOCIATIONS_ALL

543:
544: BEGIN
545: SELECT CUSTOMER_ID,SITE_USE_ID
546: INTO l_cust_id,l_site_use_id
547: FROM PO_LOCATION_ASSOCIATIONS_ALL
548: WHERE LOCATION_ID = l_dd_loc_id
549: AND org_id=l_operating_unit;
550:
551: EXCEPTION