DBA Data[Home] [Help]

APPS.WMS_REPLENISHMENT_PVT dependencies on HZ_CUST_ACCOUNTS

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

2198: AND Nvl(maa.abc_class_id, -1) = Nvl(p_abc_class_id, Nvl(maa.abc_class_id, -1))
2199: )
2200: )
2201: AND (nvl(wdd.customer_id, -1) = nvl(p_customer_id,nvl(wdd.customer_id, -1))
2202: OR wdd.customer_id in (SELECT party_id FROM hz_cust_accounts
2203: WHERE customer_class_code = p_customer_class
2204: AND status <> 'I'
2205: AND party_id = nvl(p_customer_id,party_id)))
2206: AND wdd.source_header_type_id = nvl(P_ORDER_TYPE_ID,source_header_type_id)