eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_ADJUSTMENT_EXT_PVT dependencies on OZF_OFFER_ADJUSTMENT_LINES

Line 1953: FROM ozf_offer_adjustment_lines adj

1949:
1950: CURSOR c_adjusted_line_cur(p_offer_adjustment_id IN NUMBER) IS
1951: SELECT adj.offer_adjustment_line_id,
1952: adj.list_line_id to_list_line_id
1953: FROM ozf_offer_adjustment_lines adj
1954: WHERE adj.offer_adjustment_id = p_offer_adjustment_id
1955: AND adj.created_from_adjustments = 'Y'
1956: UNION ALL
1957: SELECT adj.offer_adjustment_line_id,

Line 1959: FROM ozf_offer_adjustment_lines adj,

1955: AND adj.created_from_adjustments = 'Y'
1956: UNION ALL
1957: SELECT adj.offer_adjustment_line_id,
1958: to_list_line_id
1959: FROM ozf_offer_adjustment_lines adj,
1960: qp_list_lines lines,
1961: ozf_offer_adj_rltd_lines rltd
1962: WHERE adj.offer_adjustment_id = p_offer_adjustment_id
1963: AND lines.list_line_type_code = 'DIS'

Line 2046: ozf_offer_adjustment_lines adj_line,

2042: line.fulfillment_base -- Catch Weight ER
2043: FROM oe_order_lines_all line,
2044: ozf_adj_temp_eligibility temp,
2045: ozf_offer_adjustments_b adj,
2046: ozf_offer_adjustment_lines adj_line,
2047: ozf_offers off,
2048: qp_list_lines lines,
2049: qp_list_headers_all qp,
2050: qp_pricing_attributes qpa

Line 2081: FROM ozf_offer_adjustment_lines);

2077: FROM ozf_offer_adj_rltd_lines adjr START WITH adjr.from_list_line_id = adj_line.list_line_id
2078: AND adjr.offer_adjustment_id = adj_line.offer_adjustment_id CONNECT BY PRIOR adjr.from_list_line_id = adjr.to_list_line_id
2079: UNION ALL
2080: SELECT list_line_id
2081: FROM ozf_offer_adjustment_lines);
2082:
2083:
2084: CURSOR c_order_header2 IS
2085: SELECT /*+ parallel(line) */ line.header_id,

Line 2145: ozf_offer_adjustment_lines adj_line,

2141: line.fulfillment_base -- Catch Weight ER
2142: FROM oe_order_lines_all line,
2143: ozf_adj_temp_eligibility temp,
2144: ozf_offer_adjustments_b adj,
2145: ozf_offer_adjustment_lines adj_line,
2146: ozf_offers off,
2147: qp_list_lines lines,
2148: qp_list_headers_all qp,
2149: qp_pricing_attributes qpa

Line 2180: FROM ozf_offer_adjustment_lines);

2176: FROM ozf_offer_adj_rltd_lines adjr START WITH adjr.from_list_line_id = adj_line.list_line_id
2177: AND adjr.offer_adjustment_id = adj_line.offer_adjustment_id CONNECT BY PRIOR adjr.from_list_line_id = adjr.to_list_line_id
2178: UNION ALL
2179: SELECT list_line_id
2180: FROM ozf_offer_adjustment_lines);
2181:
2182: --These two cursors are needed when a volume offer ACTIVE
2183: -- backdated adjustment exists.
2184: --union_all instead on union will improve the query perf but

Line 2251: ozf_offer_adjustment_lines adj_line,

2247: line.fulfillment_base -- Catch Weight ER
2248: FROM oe_order_lines_all line,
2249: ozf_adj_temp_eligibility temp,
2250: ozf_offer_adjustments_b adj,
2251: ozf_offer_adjustment_lines adj_line,
2252: ozf_offers off,
2253: qp_list_lines lines,
2254: qp_list_headers_all qp,
2255: qp_pricing_attributes qpa

Line 2286: FROM ozf_offer_adjustment_lines)

2282: FROM ozf_offer_adj_rltd_lines adjr START WITH adjr.from_list_line_id = adj_line.list_line_id
2283: AND adjr.offer_adjustment_id = adj_line.offer_adjustment_id CONNECT BY PRIOR adjr.from_list_line_id = adjr.to_list_line_id
2284: UNION ALL
2285: SELECT list_line_id
2286: FROM ozf_offer_adjustment_lines)
2287: UNION ALL
2288: SELECT
2289: /*+ leading(temp) use_nl(temp line header) */ line.header_id,
2290: line.line_id,

Line 2435: ozf_offer_adjustment_lines adj_line,

2431: line.fulfillment_base -- Catch Weight ER
2432: FROM oe_order_lines_all line,
2433: ozf_adj_temp_eligibility temp,
2434: ozf_offer_adjustments_b adj,
2435: ozf_offer_adjustment_lines adj_line,
2436: ozf_offers off,
2437: qp_list_lines lines,
2438: qp_list_headers_all qp,
2439: qp_pricing_attributes qpa

Line 2470: FROM ozf_offer_adjustment_lines)

2466: FROM ozf_offer_adj_rltd_lines adjr START WITH adjr.from_list_line_id = adj_line.list_line_id
2467: AND adjr.offer_adjustment_id = adj_line.offer_adjustment_id CONNECT BY PRIOR adjr.from_list_line_id = adjr.to_list_line_id
2468: UNION ALL
2469: SELECT list_line_id
2470: FROM ozf_offer_adjustment_lines)
2471: UNION ALL
2472: SELECT
2473: /*+ parallel(line) */ line.header_id,
2474: line.line_id,

Line 4809: FROM ozf_offer_adjustment_lines

4805: AND off.qp_list_header_id = qp.list_header_id;
4806:
4807: CURSOR c_adj_info(p_list_line_id IN NUMBER) IS
4808: SELECT created_from_adjustments
4809: FROM ozf_offer_adjustment_lines
4810: WHERE list_line_id = p_list_line_id;
4811:
4812: CURSOR c_cust_number(p_header_id IN NUMBER) IS
4813: SELECT cust.cust_account_id

Line 5328: FROM ozf_offer_adjustment_lines

5324: WHERE qp_list_header_id = p_list_header_id;
5325:
5326: CURSOR c_adj_info(p_list_line_id IN NUMBER) IS
5327: SELECT created_from_adjustments
5328: FROM ozf_offer_adjustment_lines
5329: WHERE list_line_id = p_list_line_id;
5330:
5331: CURSOR c_cust_number(p_header_id IN NUMBER) IS
5332: SELECT cust.cust_account_id

Line 6030: ozf_offer_adjustment_lines adjl,

6026: ,util.reference_id
6027: ,util.exchange_rate_type
6028: FROM ozf_funds_utilized_all_b util,
6029: ozf_temp_eligibility temp,
6030: ozf_offer_adjustment_lines adjl,
6031: oe_order_lines_all ol,
6032: oe_price_adjustments oe
6033: WHERE util.plan_type = 'OFFR'
6034: AND product_id IS NOT NULL

Line 6087: ozf_offer_adjustment_lines adjl,

6083: ,util.reference_id
6084: ,util.exchange_rate_type
6085: FROM ozf_funds_utilized_all_b util,
6086: ozf_temp_eligibility temp,
6087: ozf_offer_adjustment_lines adjl,
6088: OZF_RESALE_ADJUSTMENTS_ALL oe
6089: WHERE util.plan_type = 'OFFR'
6090: AND product_id IS NOT NULL
6091: AND util.plan_id = p_qp_list_header_id

Line 6127: ozf_offer_adjustment_lines adjl,

6123: ) amount
6124: FROM ozf_funds_utilized_all_b util,
6125: oe_price_adj_assocs assocs,
6126: oe_price_adjustments oe,
6127: ozf_offer_adjustment_lines adjl,
6128: ozf_temp_eligibility temp
6129: WHERE util.plan_id = p_qp_list_header_id
6130: AND util.product_id = DECODE (temp.eligibility_id, -1, util.product_id, temp.eligibility_id)
6131: AND temp.offer_adjustment_line_id = adjl.offer_adjustment_line_id

Line 6172: ozf_offer_adjustment_lines adjl,

6168: ,util.reference_id
6169: ,util.exchange_rate_type
6170: FROM ozf_funds_utilized_all_b util,
6171: ozf_temp_eligibility temp,
6172: ozf_offer_adjustment_lines adjl,
6173: oe_order_lines_all ol,
6174: oe_price_adjustments oe
6175: WHERE util.plan_type = 'OFFR'
6176: AND product_id IS NOT NULL

Line 6226: ozf_offer_adjustment_lines adjl,

6222: ,util.reference_id
6223: ,util.exchange_rate_type
6224: FROM ozf_funds_utilized_all_b util,
6225: ozf_temp_eligibility temp,
6226: ozf_offer_adjustment_lines adjl,
6227: OZF_RESALE_ADJUSTMENTS_ALL oe
6228: WHERE util.plan_type = 'OFFR'
6229: AND product_id IS NOT NULL
6230: AND util.plan_id = p_qp_list_header_id

Line 6276: ozf_offer_adjustment_lines adjl,

6272: ,util.reference_id
6273: ,util.exchange_rate_type
6274: FROM ozf_funds_utilized_all_b util,
6275: ozf_temp_eligibility temp,
6276: ozf_offer_adjustment_lines adjl,
6277: oe_order_lines_all ol,
6278: oe_price_adjustments oe
6279: WHERE util.plan_type = 'OFFR'
6280: AND product_id IS NOT NULL

Line 6331: ozf_offer_adjustment_lines adjl,

6327: ,util.reference_id
6328: ,util.exchange_rate_type
6329: FROM ozf_funds_utilized_all_b util,
6330: ozf_temp_eligibility temp,
6331: ozf_offer_adjustment_lines adjl,
6332: OZF_RESALE_ADJUSTMENTS_ALL oe
6333: WHERE util.plan_type = 'OFFR'
6334: AND product_id IS NOT NULL
6335: AND util.plan_id = p_qp_list_header_id

Line 6373: ozf_offer_adjustment_lines adjl,

6369: ,util.reference_type
6370: ,util.reference_id
6371: ,util.exchange_rate_type
6372: FROM ozf_funds_utilized_all_b util,
6373: ozf_offer_adjustment_lines adjl,
6374: oe_order_lines_all ol,
6375: oe_price_adjustments oe
6376: WHERE util.plan_type = 'OFFR'
6377: AND util.plan_id = p_qp_list_header_id

Line 6423: ozf_offer_adjustment_lines adjl,

6419: ,util.reference_id
6420: ,util.exchange_rate_type
6421: FROM ozf_funds_utilized_all_b util,
6422: ozf_temp_eligibility temp,
6423: ozf_offer_adjustment_lines adjl,
6424: oe_order_lines_all ol,
6425: oe_price_adjustments oe
6426: WHERE util.plan_type = 'OFFR'
6427: AND product_id IS NOT NULL

Line 6838: FROM ozf_offer_adjustment_lines adjl, qp_pricing_attributes qppa

6834: CURSOR c_off_adj_lines IS
6835: SELECT offer_adjustment_line_id,
6836: qppa.product_attribute,
6837: qppa.product_attr_value
6838: FROM ozf_offer_adjustment_lines adjl, qp_pricing_attributes qppa
6839: WHERE adjl.offer_adjustment_id = p_offer_adjustment_id AND adjl.list_line_id = qppa.list_line_id;
6840: BEGIN
6841: -- ozf_utility_pvt.debug_message('enter validate_product_budget obj_id=' || p_object_id || ' budget_id=' || p_budget_id);
6842:

Line 7428: ozf_offer_adjustment_lines adjl

7424: ) /*
7425: select product_id , cust_account_id , fund_id , sum(DECODE(adjl.arithmetic_operator,'AMOUNT', (adjl.modified_discount - adjl.original_discount),
7426: (( adjl.modified_discount - adjl.original_discount)* amount/adjl.original_discount))) AMount
7427: from ozf_funds_utilized_all_vl util , ozf_temp_eligibility temp,
7428: ozf_offer_adjustment_lines adjl
7429: where util.plan_type = 'OFFR'
7430: and product_id IS NOT NULL and util.plan_id = 7909
7431: and util.product_id = temp.eligibility_id
7432: and temp.offer_adjustment_line_id = adjl.offer_adjustment_line_id