APPS.ENI_DBI_UCO_LOAD_PKG dependencies on GL_SETS_OF_BOOKS

Line 197: gl_sets_of_books gsob

193: rank() over (partition by cec.inventory_item_id, cec.organization_id, trunc(cec.last_update_date),
194: gsob.currency_code order by cec.cost_update_id desc) r
195: from cst_elemental_costs cec,
196: hr_organization_information hoi,
197: gl_sets_of_books gsob
198: where cec.organization_id = hoi.organization_id
199: and hoi.org_information_context = 'Accounting Information'
200: and hoi.org_information1 = to_char (gsob.set_of_books_id)
201: and cec.last_update_date >= l_start_date

Line 266: gl_sets_of_books gsob

262: cql.layer_id,
263: trunc (mmt.transaction_date)) x,
264: mtl_cst_actual_cost_details mcacd,
265: hr_organization_information hoi,
266: gl_sets_of_books gsob
267: where mcacd.transaction_id = x.transaction_id
268: and mcacd.organization_id = x.organization_id
269: and mcacd.layer_id = x.layer_id
270: and x.organization_id = hoi.organization_id

Line 772: gl_sets_of_books gsob

768: rank() over (partition by cec.inventory_item_id, cec.organization_id, trunc(cec.last_update_date),
769: gsob.currency_code order by cec.cost_update_id desc) r
770: from cst_elemental_costs cec,
771: hr_organization_information hoi,
772: gl_sets_of_books gsob
773: where cec.organization_id = hoi.organization_id
774: and hoi.org_information_context = 'Accounting Information'
775: and hoi.org_information1 = to_char (gsob.set_of_books_id)
776: and cec.cost_update_id >= l_processed_cost_id

Line 856: gl_sets_of_books gsob

852: cql.layer_id,
853: trunc (mmt.transaction_date)) x,
854: mtl_cst_actual_cost_details mcacd,
855: hr_organization_information hoi,
856: gl_sets_of_books gsob
857: where mcacd.transaction_id = x.transaction_id
858: and mcacd.organization_id = x.organization_id
859: and mcacd.layer_id = x.layer_id
860: and x.organization_id = hoi.organization_id