69: ra_customer_trx_lines_all rcl,
70: ap_invoice_distributions_all aid,
71: ap_invoices_all ai,
72: mtl_material_transactions mmt,
73: mtl_parameters mp
74: WHERE ai.source = 'Intercompany'
75: AND aid.invoice_id = ai.invoice_id
76: and aid.org_id = ai.org_id
77: and rcl.CUSTOMER_TRX_LINE_ID = to_number(aid.REFERENCE_1)
172:
173: CURSOR c_org IS
174: SELECT avg(nvl(Vsize(organization_id), 0)) org_id,
175: avg(nvl(Vsize(organization_code), 0)) org_code
176: FROM mtl_parameters;
177:
178: CURSOR c_act_usage IS
179: SELECT AVG(Nvl(Vsize(primary_quantity), 0))
180: FROM wip_transactions