APPS.OZF_NET_ACCRUAL_ENGINE_PVT dependencies on OZF_FUNDS_UTILIZED_ALL_B

Line 1213: FROM ozf_funds_utilized_all_b

1209:
1210: -- find accruals already made by the referral
1211: CURSOR c_existing_accruals IS
1212: SELECT NVL(DECODE(gl_posted_flag, 'Y', plan_curr_amount), 0) line_amount, product_id
1213: FROM ozf_funds_utilized_all_b
1214: WHERE reference_type = 'LEAD_REFERRAL'
1215: AND reference_id = p_referral_id
1216: AND plan_type = 'OFFR'
1217: AND plan_id = p_list_hdr_id

Line 1879: Not Unique Index: OZF_FUNDS_UTILIZED_ALL_B_N14

1875: AND OL.HEADER_ID = OH.HEADER_ID
1876: AND OH.ORDER_TYPE_ID = p_order_type_id;
1877:
1878: /* Indexes on utilization table
1879: Not Unique Index: OZF_FUNDS_UTILIZED_ALL_B_N14
1880: REFERENCE_TYPE TRX_LINE
1881: REFERENCE_ID customer_trx_line_id
1882:
1883: Not Unique Index: OZF_FUNDS_UTILIZED_ALL_B_N19

Line 1883: Not Unique Index: OZF_FUNDS_UTILIZED_ALL_B_N19

1879: Not Unique Index: OZF_FUNDS_UTILIZED_ALL_B_N14
1880: REFERENCE_TYPE TRX_LINE
1881: REFERENCE_ID customer_trx_line_id
1882:
1883: Not Unique Index: OZF_FUNDS_UTILIZED_ALL_B_N19
1884: OBJECT_TYPE CM OR DM
1885: OBJECT_ID customer_trx_id
1886:
1887: Not Unique Index: OZF_FUNDS_UTILIZED_ALL_B_N9

Line 1887: Not Unique Index: OZF_FUNDS_UTILIZED_ALL_B_N9

1883: Not Unique Index: OZF_FUNDS_UTILIZED_ALL_B_N19
1884: OBJECT_TYPE CM OR DM
1885: OBJECT_ID customer_trx_id
1886:
1887: Not Unique Index: OZF_FUNDS_UTILIZED_ALL_B_N9
1888: PRODUCT_ID inventory_item_id
1889: PRODUCT_LEVEL_TYPE PRODUCT
1890: */
1891: -- nepanda : Fix for Bug 09204988

Line 1901: FROM ozf_funds_utilized_all_b a,

1897: a.cust_account_id,
1898: a.adjustment_date conv_date,
1899: a.currency_code,
1900: a.org_id --Added for bug 7030415
1901: FROM ozf_funds_utilized_all_b a,
1902: ozf_offers b,
1903: ozf_na_products_temp c
1904: WHERE a.plan_type = 'OFFR'
1905: AND a.plan_id = b.qp_list_header_id

Line 1928: -- FROM ozf_funds_utilized_all_b a,

1924: -- a.object_type,
1925: -- a.reference_type,
1926: -- a.reference_id,
1927: -- a.org_id --Added for bug 7030415
1928: -- FROM ozf_funds_utilized_all_b a,
1929: -- ozf_offers b,
1930: -- ozf_na_products_temp c
1931: -- WHERE a.plan_type = 'OFFR'
1932: -- AND a.plan_id = b.qp_list_header_id

Line 1955: FROM ozf_funds_utilized_all_b a,

1951: a.object_type,
1952: a.reference_type,
1953: a.reference_id,
1954: a.org_id --Added for bug 7030415
1955: FROM ozf_funds_utilized_all_b a,
1956: ozf_offers b,
1957: ozf_na_products_temp c
1958: WHERE a.plan_type = 'OFFR'
1959: AND a.plan_id = b.qp_list_header_id

Line 2012: FROM ozf_funds_utilized_all_b

2008: CURSOR c_get_util_amt(p_customer_trx_line_id NUMBER,
2009: p_inventory_item_id NUMBER,
2010: p_qp_list_header_id NUMBER) IS
2011: SELECT NVL(SUM(plan_curr_amount),0)
2012: FROM ozf_funds_utilized_all_b
2013: WHERE reference_type = 'TRX_LINE'
2014: AND reference_id = p_customer_trx_line_id
2015: AND product_id = p_inventory_item_id
2016: AND product_level_type = 'PRODUCT'