APPS.OZF_NET_ACCRUAL_ENGINE_PVT dependencies on OZF_FUNDS_UTILIZED_ALL_B

Line 1116: FROM ozf_funds_utilized_all_b

1112:
1113: -- find accruals already made by the referral
1114: CURSOR c_existing_accruals IS
1115: SELECT NVL(DECODE(gl_posted_flag, 'Y', plan_curr_amount), 0) line_amount, product_id
1116: FROM ozf_funds_utilized_all_b
1117: WHERE reference_type = 'LEAD_REFERRAL'
1118: AND reference_id = p_referral_id
1119: AND plan_type = 'OFFR'
1120: AND plan_id = p_list_hdr_id

Line 1580: Not Unique Index: OZF_FUNDS_UTILIZED_ALL_B_N14

1576: AND ol.header_id = oh.header_id
1577: AND oh.order_type_id = p_order_type_id;
1578:
1579: /* Indexes on utilization table
1580: Not Unique Index: OZF_FUNDS_UTILIZED_ALL_B_N14
1581: REFERENCE_TYPE TRX_LINE
1582: REFERENCE_ID customer_trx_line_id
1583:
1584: Not Unique Index: OZF_FUNDS_UTILIZED_ALL_B_N19

Line 1584: Not Unique Index: OZF_FUNDS_UTILIZED_ALL_B_N19

1580: Not Unique Index: OZF_FUNDS_UTILIZED_ALL_B_N14
1581: REFERENCE_TYPE TRX_LINE
1582: REFERENCE_ID customer_trx_line_id
1583:
1584: Not Unique Index: OZF_FUNDS_UTILIZED_ALL_B_N19
1585: OBJECT_TYPE CM OR DM
1586: OBJECT_ID customer_trx_id
1587:
1588: Not Unique Index: OZF_FUNDS_UTILIZED_ALL_B_N9

Line 1588: Not Unique Index: OZF_FUNDS_UTILIZED_ALL_B_N9

1584: Not Unique Index: OZF_FUNDS_UTILIZED_ALL_B_N19
1585: OBJECT_TYPE CM OR DM
1586: OBJECT_ID customer_trx_id
1587:
1588: Not Unique Index: OZF_FUNDS_UTILIZED_ALL_B_N9
1589: PRODUCT_ID inventory_item_id
1590: PRODUCT_LEVEL_TYPE PRODUCT
1591: */
1592: CURSOR c_tm_lines(p_activity_media_id NUMBER,

Line 1601: FROM ozf_funds_utilized_all_b a,

1597: a.cust_account_id,
1598: a.adjustment_date conv_date,
1599: a.currency_code,
1600: a.org_id --Added for bug 7030415
1601: FROM ozf_funds_utilized_all_b a,
1602: ozf_offers b,
1603: ozf_na_products_temp c
1604: WHERE a.plan_type = 'OFFR'
1605: AND a.plan_id = b.qp_list_header_id

Line 1617: FROM ozf_funds_utilized_all_b

1613: CURSOR c_get_util_amt(p_customer_trx_line_id NUMBER,
1614: p_inventory_item_id NUMBER,
1615: p_qp_list_header_id NUMBER) IS
1616: SELECT NVL(SUM(plan_curr_amount),0)
1617: FROM ozf_funds_utilized_all_b
1618: WHERE reference_type = 'TRX_LINE'
1619: AND reference_id = p_customer_trx_line_id
1620: AND product_id = p_inventory_item_id
1621: AND product_level_type = 'PRODUCT'