DBA Data[Home] [Help]

APPS.INVTTMTX dependencies on MTL_SYSTEM_ITEMS

Line 514: mtl_system_items msi

510: mmtt.transaction_quantity, mmtt.primary_quantity, mmtt.lot_number,
511: mmtt.lot_expiration_date, mmtt.transaction_header_id,
512: mmtt.transaction_temp_id, msi.default_lot_status_id
513: FROM mtl_material_transactions_temp mmtt,
514: mtl_system_items msi
515: WHERE mmtt.transaction_header_id = hdr_id AND mmtt.lot_number IS
516: NOT NULL AND mmtt.transaction_header_id IS NOT NULL
517: AND msi.inventory_item_id = mmtt.inventory_item_id
518: AND msi.organization_id = mmtt.organization_id) ; */

Line 718: mtl_system_items msi,

714: , NVL(mln.hold_date, NVL(mln.origination_date, mmtt.transaction_date) + hold_days) /* Jalaj Srivastava Bug 5527373*/
715: , mmtt.reason_id
716: /* INVCONV Anand Thiyagarajan 22-Oct-2004 End */
717: FROM mtl_material_transactions_temp mmtt,
718: mtl_system_items msi,
719: mtl_lot_numbers mln
720: WHERE mmtt.transaction_header_id = hdr_id AND mmtt.lot_number IS
721: NOT NULL AND mmtt.transaction_header_id IS NOT NULL
722: AND msi.inventory_item_id = mmtt.inventory_item_id