DBA Data[Home] [Help]

APPS.WMS_REPLENISHMENT_PVT dependencies on HZ_CUST_ACCOUNTS

Line 2135: OR wdd.customer_id in (SELECT party_id FROM hz_cust_accounts

2131: AND nvl(MAA.ASSIGNMENT_GROUP_ID, -1) = nvl(p_ABC_assignment_group_id, nvl(MAA.ASSIGNMENT_GROUP_ID, -1))
2132: AND nvl(MAA.ABC_CLASS_ID, -1) = nvl(p_abc_class_id, nvl(MAA.ABC_CLASS_ID, -1))
2133:
2134: AND (nvl(wdd.customer_id, -1) = nvl(p_customer_id,nvl(wdd.customer_id, -1))
2135: OR wdd.customer_id in (SELECT party_id FROM hz_cust_accounts
2136: WHERE customer_class_code = p_customer_class
2137: AND status <> 'I'
2138: AND party_id = nvl(p_customer_id,party_id)))
2139: AND wdd.source_header_type_id = nvl(P_ORDER_TYPE_ID,source_header_type_id)