DBA Data[Home] [Help]

APPS.OZF_NET_ACCRUAL_ENGINE_PVT dependencies on OZF_ACTIVITY_CUSTOMERS

Line 84: FROM ozf_activity_customers

80: WHERE cust_account_id = p_sold_to_org_id;
81:
82: CURSOR c_customer_qualified(p_party_id NUMBER) IS
83: SELECT 'Y'
84: FROM ozf_activity_customers
85: WHERE (
86: (site_use_id = p_invoice_to_org_id AND site_use_code = 'BILL_TO') OR
87: (site_use_id = p_ship_to_org_id AND site_use_code = 'SHIP_TO') OR
88: (party_id = p_party_id AND site_use_code IS NULL) OR

Line 97: FROM ozf_activity_customers

93: AND ROWNUM = 1;
94:
95: CURSOR c_cust_acct_qualified(p_party_id NUMBER) IS
96: SELECT 'Y'
97: FROM ozf_activity_customers
98: WHERE (
99: (cust_account_id = p_sold_to_org_id) OR
100: (party_id = p_party_id AND site_use_code IS NULL) OR
101: (party_id = -1)