APPS.OPI_DBI_CURR_INV_EXP_PKG dependencies on MTL_ONHAND_QUANTITIES

Line 522: MTL_ONHAND_QUANTITIES and MTL_LOT_NUMBERS. All inventory that is not

518: /* extract_expired_inventory
519:
520: Extract the onhand and expired lot controlled inventory quantity/value
521: as of the run time from the inventory current snapshot tables,
522: MTL_ONHAND_QUANTITIES and MTL_LOT_NUMBERS. All inventory that is not
523: lot controlled will be ignored in this extraction.
524:
525: Inventory value is computed using the current item costs stored in the
526: system.

Line 564: -- MTL_ONHAND_QUANTITIES and MTL_LOT_NUMBERS. All inventory that is not

560: -- Extract data. Query logic is as follows:
561: --
562: -- Extract the onhand and expired lot controlled inventory quantity and
563: -- value as of the run time from the inventory current snapshot tables,
564: -- MTL_ONHAND_QUANTITIES and MTL_LOT_NUMBERS. All inventory that is not
565: -- lot controlled will be ignored in this extraction. Since the MTL
566: -- tables store quantity in the item's primary uom, there is no need
567: -- for unit of measure conversions.
568: --

Line 638: -- in MTL_ONHAND_QUANTITIES that belong to process organizations.These orgs

634: -- level records.
635:
636: -- For process organizations, we use the get_opm_item_cost API to get
637: -- the cost as on the run date. We collect cost for the lot-controlled items
638: -- in MTL_ONHAND_QUANTITIES that belong to process organizations.These orgs
639: -- are determined from the process_enabled_flag = 'Y' from MTL_PARAMETERS.
640: --
641: INSERT /*+ append parallel (opi_dbi_curr_inv_exp_f) */
642: INTO opi_dbi_curr_inv_exp_f (

Line 758: FROM mtl_onhand_quantities moq,

754: ELSE
755: 0
756: END)
757: expired_qty
758: FROM mtl_onhand_quantities moq,
759: mtl_lot_numbers mln
760: WHERE moq.inventory_item_id = mln.inventory_item_id
761: AND moq.organization_id = mln.organization_id
762: AND moq.lot_number = mln.lot_number