APPS.OZF_ADJUSTMENT_EXT_PVT dependencies on OZF_ACTIVITY_CUSTOMERS

Line 252: FROM ozf_activity_customers

248: WHERE cust_account_id = p_sold_to_org_id;
249:
250: CURSOR c_customer_qualified(p_invoice_to_org_id IN NUMBER, p_ship_to_org_id IN NUMBER, p_party_id NUMBER) IS
251: SELECT 'Y', object_type, qp_qualifier_group
252: FROM ozf_activity_customers
253: WHERE (
254: (site_use_id = p_invoice_to_org_id AND site_use_code = 'BILL_TO') OR
255: (site_use_id = p_ship_to_org_id AND site_use_code = 'SHIP_TO') OR
256: (party_id = p_party_id AND site_use_code IS NULL) OR

Line 265: FROM ozf_activity_customers

261: AND ROWNUM = 1;
262:
263: CURSOR c_cust_acct_qualified(p_sold_to_org_id IN NUMBER, p_party_id NUMBER) IS
264: SELECT 'Y', object_type, qp_qualifier_group
265: FROM ozf_activity_customers
266: WHERE (
267: (cust_account_id = p_sold_to_org_id) OR
268: (party_id = p_party_id AND site_use_code IS NULL) OR
269: (party_id = -1)

Line 2567: FROM ozf_activity_customers

2563: WHERE header_id = p_header_id;
2564:
2565: CURSOR c_customer_qualified(p_invoice_to_org_id IN NUMBER, p_ship_to_org_id IN NUMBER, p_party_id NUMBER, p_list_header_id NUMBER) IS
2566: SELECT 'Y', object_type, qp_qualifier_group
2567: FROM ozf_activity_customers
2568: WHERE (
2569: (site_use_id = p_invoice_to_org_id AND site_use_code = 'BILL_TO') OR
2570: (site_use_id = p_ship_to_org_id AND site_use_code = 'SHIP_TO') OR
2571: (party_id = p_party_id AND site_use_code IS NULL) OR

Line 2580: FROM ozf_activity_customers

2576: AND ROWNUM = 1;
2577:
2578: CURSOR c_cust_acct_qualified(p_sold_to_org_id IN NUMBER, p_party_id NUMBER, p_list_header_id NUMBER) IS
2579: SELECT 'Y', object_type, qp_qualifier_group
2580: FROM ozf_activity_customers
2581: WHERE (
2582: (cust_account_id = p_sold_to_org_id) OR
2583: (party_id = p_party_id AND site_use_code IS NULL) OR
2584: (party_id = -1)