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 5866: CURSOR csr_ams_act_products(cv_agreement_number IN VARCHAR2 ,cv_product_id IN NUMBER) IS

5862: , s.currency_code;
5863: -- bug # 7453430 fixed by ateotia(-)
5864:
5865: -- added for Bugfix 5404951
5866: CURSOR csr_ams_act_products(cv_agreement_number IN VARCHAR2 ,cv_product_id IN NUMBER) IS
5867: select act.SCAN_VALUE ,act.UOM_CODE , act.Quantity , off.TRANSACTION_CURRENCY_CODE
5868: from ozf_offers off , ams_act_products act
5869: where offer_code = cv_agreement_number
5870: and ARC_ACT_PRODUCT_USED_BY = 'OFFR'

Line 5868: from ozf_offers off , ams_act_products act

5864:
5865: -- added for Bugfix 5404951
5866: CURSOR csr_ams_act_products(cv_agreement_number IN VARCHAR2 ,cv_product_id IN NUMBER) IS
5867: select act.SCAN_VALUE ,act.UOM_CODE , act.Quantity , off.TRANSACTION_CURRENCY_CODE
5868: from ozf_offers off , ams_act_products act
5869: where offer_code = cv_agreement_number
5870: and ARC_ACT_PRODUCT_USED_BY = 'OFFR'
5871: AND ACT_PRODUCT_USED_BY_ID = off.qp_list_header_id
5872: AND INVENTORY_ITEM_ID = cv_product_id;

Line 6015: OPEN csr_ams_act_products(l_agreement_number ,l_product_id );

6011: -- bug # 7453430 fixed by ateotia(-)
6012:
6013: EXIT WHEN csr_batch_line%NOTFOUND;
6014:
6015: OPEN csr_ams_act_products(l_agreement_number ,l_product_id );
6016: FETCH csr_ams_act_products INTO l_scan_value
6017: , l_offer_uom_code
6018: , l_offer_quantity
6019: , l_trans_curr_code;

Line 6016: FETCH csr_ams_act_products INTO l_scan_value

6012:
6013: EXIT WHEN csr_batch_line%NOTFOUND;
6014:
6015: OPEN csr_ams_act_products(l_agreement_number ,l_product_id );
6016: FETCH csr_ams_act_products INTO l_scan_value
6017: , l_offer_uom_code
6018: , l_offer_quantity
6019: , l_trans_curr_code;
6020: CLOSE csr_ams_act_products;

Line 6020: CLOSE csr_ams_act_products;

6016: FETCH csr_ams_act_products INTO l_scan_value
6017: , l_offer_uom_code
6018: , l_offer_quantity
6019: , l_trans_curr_code;
6020: CLOSE csr_ams_act_products;
6021:
6022: -- calculate claim amount
6023: IF l_line_curr_code = l_claim_curr_code THEN
6024: l_new_line_amount := l_line_amount;

Line 6290: FROM ams_act_products

6286: l_total_amt_remaining NUMBER;
6287:
6288: CURSOR csr_auto_adjust(cv_activity_product_id IN NUMBER) IS
6289: SELECT adjustment_flag
6290: FROM ams_act_products
6291: WHERE activity_product_id = cv_activity_product_id;
6292:
6293: CURSOR csr_count_workflow(cv_claim_line_id IN NUMBER) IS
6294: SELECT count(*)

Line 6295: FROM ozf_claim_lines_util lu, ams_act_products ap

6291: WHERE activity_product_id = cv_activity_product_id;
6292:
6293: CURSOR csr_count_workflow(cv_claim_line_id IN NUMBER) IS
6294: SELECT count(*)
6295: FROM ozf_claim_lines_util lu, ams_act_products ap
6296: ,ozf_claim_lines cln1, ozf_claim_lines cln2
6297: WHERE cln1.claim_line_id = cv_claim_line_id
6298: AND cln1.claim_id = cln2.claim_id
6299: AND lu.claim_line_id = cln2.claim_line_id

Line 6724: FROM ams_act_products

6720: SELECT uom_code
6721: , quantity
6722: , scan_value
6723: , inventory_item_id
6724: FROM ams_act_products
6725: WHERE activity_product_id = cv_activity_product_id;
6726:
6727: CURSOR csr_offer_status(cv_offer_id IN NUMBER) IS
6728: SELECT status_code

Line 6739: ams_act_products amp

6735: SELECT NVL(SUM(scan_unit * amp.quantity ), 0)
6736: FROM ozf_claim_lines_util lu,
6737: ozf_claims c,
6738: ozf_claim_lines cl,
6739: ams_act_products amp
6740: WHERE lu.activity_product_id = cv_activity_product_id
6741: AND cl.claim_line_id = lu.claim_line_id
6742: AND cl.claim_id = c.claim_id
6743: AND c.status_code <> 'CLOSED'

Line 8107: FROM ams_act_products

8103: SELECT uom_code
8104: , quantity
8105: , scan_value
8106: , inventory_item_id
8107: FROM ams_act_products
8108: WHERE activity_product_id = cv_activity_product_id;
8109:
8110: CURSOR csr_utiz_amount(cv_line_util_id IN NUMBER) IS
8111: SELECT util_curr_amount

Line 8794: FROM ozf_claim_lines_util lu, ams_act_products ap

8790: ,lu.activity_product_id
8791: ,lu.scan_unit
8792: ,ap.act_product_used_by_id
8793: ,ap.adjustment_flag
8794: FROM ozf_claim_lines_util lu, ams_act_products ap
8795: ,ozf_claim_lines cln
8796: WHERE cln.claim_id = cv_claim_id
8797: AND lu.claim_line_id = cln.claim_line_id
8798: AND lu.activity_product_id = ap.activity_product_id

Line 8820: ,ams_act_products amp

8816: SELECT SUM(lu.scan_unit * amp.quantity)
8817: ,lu.utilization_id
8818: FROM ozf_claim_lines_util_all lu
8819: ,ozf_claim_lines_all cln
8820: ,ams_act_products amp
8821: WHERE cln.claim_id = cv_claim_id
8822: AND lu.claim_line_id = cln.claim_line_id
8823: AND lu.activity_product_id = amp.activity_product_id
8824: GROUP BY lu.utilization_id;

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

8934:
8935: -- yizhang: 15-JAN-2003: should we decide to support adjustment workflow, we need to
8936: -- change the settlement fetcher process
8937: -- mchang: As of 24-OCT-2002, we don't support manual adjust over utilization. TM raise
8938: -- error everytime if ams_act_products.adjustment_flag is 'N'.
8939: IF OZF_DEBUG_LOW_ON THEN
8940: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
8941: FND_MESSAGE.Set_Token('TEXT',l_full_name||' : Manual Adjust Over Utilization is not supported.');
8942: FND_MSG_PUB.Add;