DBA Data[Home] [Help]

APPS.AHL_MM_MTL_MGT_PVT dependencies on HZ_CUST_ACCOUNTS

Line 2114: HZ_CUST_ACCOUNTS CUST

2110: SELECT LOC.LOCATION_ID
2111: INTO L_DESTINATION_LOC_ID
2112: FROM HR_LOCATIONS_ALL LOC,
2113: PO_LOCATION_ASSOCIATIONS_ALL PLOC,
2114: HZ_CUST_ACCOUNTS CUST
2115: WHERE LOC.INVENTORY_ORGANIZATION_ID = l_demand_org_id
2116: AND LOC.LOCATION_ID = PLOC.LOCATION_ID
2117: AND PLOC.ORG_ID = L_DESTINATION_OU
2118: AND PLOC.CUSTOMER_ID = CUST.CUST_ACCOUNT_ID