DBA Data[Home] [Help]

APPS.INVTTMTX dependencies on MTL_SYSTEM_ITEMS

Line 511: mtl_system_items msi

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

Line 715: mtl_system_items msi,

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