APPS.OZF_CLAIM_ACCRUAL_PVT dependencies on OZF_RESALE_BATCHES

Line 824: ozf_resale_batches_all orba

820: CURSOR sysparam_accrual_flag_csr (p_resale_batch_id IN NUMBER)
821: IS
822: SELECT NVL(ospa.ship_debit_accrual_flag, 'F')
823: FROM ozf_sys_parameters_all ospa,
824: ozf_resale_batches_all orba
825: WHERE ospa.org_id = orba.org_id
826: AND orba.resale_batch_id = p_resale_batch_id;
827:
828: l_accrual_flag VARCHAR2(1);

Line 4919: ozf_resale_batches_all orb,

4915: ) IS
4916: SELECT
4917: sum(orl.total_accepted_amount)
4918: FROM
4919: ozf_resale_batches_all orb,
4920: ozf_resale_lines_int_all orl
4921: WHERE
4922: orb.batch_type = 'CHARGEBACK'
4923: AND orb.resale_batch_id = orl.resale_batch_id

Line 5530: ozf_resale_batches_all orb,

5526: SUM(orl.total_accepted_amount) total_amount,
5527: orl.inventory_item_id product_id,
5528: orb.currency_code currency_code
5529: FROM
5530: ozf_resale_batches_all orb,
5531: ozf_resale_lines_int_all orl
5532: WHERE
5533: orb.batch_type = 'CHARGEBACK'
5534: AND orb.resale_batch_id = orl.resale_batch_id

Line 5545: ozf_resale_batches_all orb,

5541: IS
5542: SELECT
5543: orl.resale_line_int_id
5544: FROM
5545: ozf_resale_batches_all orb,
5546: ozf_resale_lines_int_all orl
5547: WHERE
5548: orb.batch_type = 'CHARGEBACK'
5549: AND orb.resale_batch_id = orl.resale_batch_id

Line 6900: FROM ozf_resale_batches

6896: SELECT partner_cust_account_id
6897: , partner_id
6898: , currency_code
6899: , partner_claim_number
6900: FROM ozf_resale_batches
6901: WHERE resale_batch_id = cv_batch_id;
6902:
6903: CURSOR csr_batch_request(cv_batch_id IN NUMBER, cv_partner_id IN NUMBER) IS
6904: SELECT r.request_header_id

Line 7391: FROM ozf_resale_batches

7387: SELECT partner_cust_account_id
7388: , partner_id
7389: , currency_code
7390: , partner_claim_number
7391: FROM ozf_resale_batches
7392: WHERE resale_batch_id = cv_batch_id;
7393:
7394: CURSOR csr_batch_line(cv_batch_id IN NUMBER, cv_partner_id IN NUMBER) IS
7395: SELECT r.request_header_id