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_CLAIM_ACCRUAL_PVT dependencies on AMS_ACT_PRODUCTS

Line 6939: CURSOR csr_ams_act_products(cv_agreement_number IN VARCHAR2 ,cv_product_id IN NUMBER) IS

6935: , uom_code
6936: , currency_code;
6937:
6938: -- added for Bugfix 5404951
6939: CURSOR csr_ams_act_products(cv_agreement_number IN VARCHAR2 ,cv_product_id IN NUMBER) IS
6940: SELECT act.SCAN_VALUE
6941: , act.UOM_CODE
6942: , act.Quantity
6943: , off.TRANSACTION_CURRENCY_CODE

Line 6945: , ams_act_products act

6941: , act.UOM_CODE
6942: , act.Quantity
6943: , off.TRANSACTION_CURRENCY_CODE
6944: FROM ozf_offers off
6945: , ams_act_products act
6946: WHERE offer_code = cv_agreement_number
6947: AND ARC_ACT_PRODUCT_USED_BY = 'OFFR'
6948: AND ACT_PRODUCT_USED_BY_ID = off.qp_list_header_id
6949: AND INVENTORY_ITEM_ID = cv_product_id;

Line 7073: OPEN csr_ams_act_products(l_agreement_number, l_product_id );

7069: , l_line_curr_code
7070: , l_line_amount;
7071: EXIT WHEN csr_batch_line%NOTFOUND;
7072:
7073: OPEN csr_ams_act_products(l_agreement_number, l_product_id );
7074: FETCH csr_ams_act_products INTO l_scan_value
7075: , l_offer_uom_code
7076: , l_offer_quantity
7077: , l_trans_curr_code;

Line 7074: FETCH csr_ams_act_products INTO l_scan_value

7070: , l_line_amount;
7071: EXIT WHEN csr_batch_line%NOTFOUND;
7072:
7073: OPEN csr_ams_act_products(l_agreement_number, l_product_id );
7074: FETCH csr_ams_act_products INTO l_scan_value
7075: , l_offer_uom_code
7076: , l_offer_quantity
7077: , l_trans_curr_code;
7078: CLOSE csr_ams_act_products;

Line 7078: CLOSE csr_ams_act_products;

7074: FETCH csr_ams_act_products INTO l_scan_value
7075: , l_offer_uom_code
7076: , l_offer_quantity
7077: , l_trans_curr_code;
7078: CLOSE csr_ams_act_products;
7079:
7080: -- calculate claim amount
7081: IF l_line_curr_code = l_claim_curr_code THEN
7082: l_new_line_amount := l_line_amount;

Line 7428: CURSOR csr_ams_act_products(cv_agreement_number IN VARCHAR2 ,cv_product_id IN NUMBER) IS

7424: , r.offer_type ;
7425:
7426:
7427: -- added for Bugfix 5404951
7428: CURSOR csr_ams_act_products(cv_agreement_number IN VARCHAR2 ,cv_product_id IN NUMBER) IS
7429: SELECT act.SCAN_VALUE
7430: , act.UOM_CODE
7431: , act.Quantity
7432: , off.TRANSACTION_CURRENCY_CODE

Line 7434: , ams_act_products act

7430: , act.UOM_CODE
7431: , act.Quantity
7432: , off.TRANSACTION_CURRENCY_CODE
7433: FROM ozf_offers off
7434: , ams_act_products act
7435: WHERE offer_code = cv_agreement_number
7436: AND ARC_ACT_PRODUCT_USED_BY = 'OFFR'
7437: AND ACT_PRODUCT_USED_BY_ID = off.qp_list_header_id
7438: AND INVENTORY_ITEM_ID = cv_product_id;

Line 7554: OPEN csr_ams_act_products(l_agreement_number ,l_product_id );

7550: EXIT WHEN csr_batch_line%NOTFOUND;
7551:
7552: -- Added logic to create claim line only when the auto claim profile is set/offer type is scan data
7553: IF(l_auto_claim_profile = 'Y') OR (l_offer_type='SCAN_DATA') THEN
7554: OPEN csr_ams_act_products(l_agreement_number ,l_product_id );
7555: FETCH csr_ams_act_products INTO l_scan_value
7556: , l_offer_uom_code
7557: , l_offer_quantity
7558: , l_trans_curr_code;

Line 7555: FETCH csr_ams_act_products INTO l_scan_value

7551:
7552: -- Added logic to create claim line only when the auto claim profile is set/offer type is scan data
7553: IF(l_auto_claim_profile = 'Y') OR (l_offer_type='SCAN_DATA') THEN
7554: OPEN csr_ams_act_products(l_agreement_number ,l_product_id );
7555: FETCH csr_ams_act_products INTO l_scan_value
7556: , l_offer_uom_code
7557: , l_offer_quantity
7558: , l_trans_curr_code;
7559: CLOSE csr_ams_act_products;

Line 7559: CLOSE csr_ams_act_products;

7555: FETCH csr_ams_act_products INTO l_scan_value
7556: , l_offer_uom_code
7557: , l_offer_quantity
7558: , l_trans_curr_code;
7559: CLOSE csr_ams_act_products;
7560:
7561: -- calculate claim amount
7562: IF l_line_curr_code = l_claim_curr_code THEN
7563: l_new_line_amount := l_line_amount;

Line 7977: FROM ams_act_products

7973: l_currOrgId NUMBER := MO_GLOBAL.GET_CURRENT_ORG_ID();
7974:
7975: CURSOR csr_auto_adjust(cv_activity_product_id IN NUMBER) IS
7976: SELECT adjustment_flag
7977: FROM ams_act_products
7978: WHERE activity_product_id = cv_activity_product_id;
7979:
7980: CURSOR csr_count_workflow(cv_claim_line_id IN NUMBER) IS
7981: SELECT count(*)

Line 7982: FROM ozf_claim_lines_util lu, ams_act_products ap

7978: WHERE activity_product_id = cv_activity_product_id;
7979:
7980: CURSOR csr_count_workflow(cv_claim_line_id IN NUMBER) IS
7981: SELECT count(*)
7982: FROM ozf_claim_lines_util lu, ams_act_products ap
7983: ,ozf_claim_lines cln1, ozf_claim_lines cln2
7984: WHERE cln1.claim_line_id = cv_claim_line_id
7985: AND cln1.claim_id = cln2.claim_id
7986: AND lu.claim_line_id = cln2.claim_line_id

Line 8672: ams_act_products amp

8668: SELECT NVL(SUM(scan_unit * amp.quantity ), 0)
8669: FROM ozf_claim_lines_util lu,
8670: ozf_claims c,
8671: ozf_claim_lines cl,
8672: ams_act_products amp
8673: WHERE lu.activity_product_id = cv_activity_product_id
8674: AND cl.claim_line_id = lu.claim_line_id
8675: AND cl.claim_id = c.claim_id
8676: AND c.status_code <> 'CLOSED'

Line 9187: FROM ams_act_products

9183: SELECT uom_code
9184: , quantity
9185: , scan_value
9186: , inventory_item_id
9187: FROM ams_act_products
9188: WHERE activity_product_id = cv_activity_product_id;
9189:
9190: CURSOR csr_offer_status(cv_offer_id IN NUMBER) IS
9191: SELECT status_code

Line 10443: FROM ams_act_products

10439: SELECT uom_code
10440: , quantity
10441: , scan_value
10442: , inventory_item_id
10443: FROM ams_act_products
10444: WHERE activity_product_id = cv_activity_product_id;
10445:
10446: --Changed cursor csr_utiz_amount currency for Multicurrency ER.
10447: /*

Line 11187: FROM ozf_claim_lines_util lu, ams_act_products ap

11183: ,lu.activity_product_id
11184: ,lu.scan_unit
11185: ,ap.act_product_used_by_id
11186: ,ap.adjustment_flag
11187: FROM ozf_claim_lines_util lu, ams_act_products ap
11188: ,ozf_claim_lines cln
11189: WHERE cln.claim_id = cv_claim_id
11190: AND lu.claim_line_id = cln.claim_line_id
11191: AND lu.activity_product_id = ap.activity_product_id

Line 11202: ,ams_act_products amp

11198: SELECT SUM(lu.scan_unit * amp.quantity)
11199: ,lu.utilization_id
11200: FROM ozf_claim_lines_util_all lu
11201: ,ozf_claim_lines_all cln
11202: ,ams_act_products amp
11203: WHERE cln.claim_id = cv_claim_id
11204: AND lu.claim_line_id = cln.claim_line_id
11205: AND lu.activity_product_id = amp.activity_product_id
11206: GROUP BY lu.utilization_id;

Line 11307: -- error everytime if ams_act_products.adjustment_flag is 'N'.

11303:
11304: -- yizhang: 15-JAN-2003: should we decide to support adjustment workflow, we need to
11305: -- change the settlement fetcher process
11306: -- mchang: As of 24-OCT-2002, we don't support manual adjust over utilization. TM raise
11307: -- error everytime if ams_act_products.adjustment_flag is 'N'.
11308: IF OZF_DEBUG_LOW_ON THEN
11309: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
11310: FND_MESSAGE.Set_Token('TEXT',l_full_name||' : Manual Adjust Over Utilization is not supported.');
11311: FND_MSG_PUB.Add;