eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GME_MOBILE_TXN dependencies on MTL_MATERIAL_TRANSACTIONS

Line 731: FROM mtl_material_transactions

727:
728: CURSOR Get_Agg_Txn IS
729: SELECT ABS(SUM (NVL(primary_quantity,0))),
730: ABS(SUM (NVL(secondary_transaction_quantity,0)))
731: FROM mtl_material_transactions
732: WHERE organization_id = p_org_id
733: AND transaction_source_id = p_batch_id
734: AND trx_source_line_id = p_material_detail_id
735: AND transaction_source_type_id = gme_common_pvt.g_txn_source_type;

Line 797: FROM mtl_material_transactions m,

793: OPEN x_txn_cursor FOR
794: SELECT m.revision,lot_number,
795: ABS(SUM (NVL(l.primary_quantity,0))),
796: ABS(SUM (NVL(l.secondary_transaction_quantity,0)))
797: FROM mtl_material_transactions m,
798: mtl_transaction_lot_numbers l
799: WHERE l.transaction_id = m.transaction_id
800: AND lot_number = NVL(p_lot_number, l.lot_number)
801: AND m.organization_id = p_org_id

Line 845: FROM mtl_material_transactions

841: IS
842: CURSOR Get_Agg_Txn IS
843: SELECT ABS(SUM (NVL(primary_quantity,0))),
844: ABS(SUM (NVL(secondary_transaction_quantity,0)))
845: FROM mtl_material_transactions
846: WHERE organization_id = p_org_id
847: AND transaction_source_id = p_batch_id
848: AND trx_source_line_id = p_material_detail_id
849: AND transaction_source_type_id = gme_common_pvt.g_txn_source_type

Line 932: FROM mtl_material_transactions m,

928: m.reason_id,
929: l.concatenated_segments,
930: TO_CHAR(transaction_date, l_date_format),
931: revision
932: FROM mtl_material_transactions m,
933: wms_item_locations_kfv l
934: WHERE trx_source_line_id = NVL(p_material_detail_id, trx_source_line_id)
935: AND transaction_source_id = p_batch_id
936: AND transaction_type_id = l_txn_type_id

Line 3453: FROM mtl_material_transactions m,

3449: m.reason_id,
3450: lc.concatenated_segments,
3451: TO_CHAR(m.transaction_date, l_date_format),
3452: revision
3453: FROM mtl_material_transactions m,
3454: mtl_transaction_lot_numbers l,
3455: wms_item_locations_kfv lc
3456: WHERE l.transaction_id = m.transaction_id
3457: AND l.lot_number = NVL(p_lot_number, l.lot_number)

Line 3532: FROM mtl_material_transactions m,

3528: m.reason_id,
3529: lc.concatenated_segments,
3530: TO_CHAR(m.transaction_date, l_date_format),
3531: revision
3532: FROM mtl_material_transactions m,
3533: mtl_transaction_lot_numbers l,
3534: wms_item_locations_kfv lc
3535: WHERE l.transaction_id = m.transaction_id
3536: AND l.lot_number = NVL(p_lot_number, l.lot_number)

Line 4473: l_mmtt_txn_rec MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE;

4469:
4470: l_mti_txn_tbl INV_CALCULATE_EXP_DATE.MTI_TAB;
4471: l_mti_txn_rec MTL_TRANSACTIONS_INTERFACE%ROWTYPE;
4472: l_mtli_txn_rec MTL_TRANSACTION_LOTS_INTERFACE%ROWTYPE;
4473: l_mmtt_txn_rec MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE;
4474: l_mtlt_txn_rec MTL_TRANSACTION_LOTS_TEMP%ROWTYPE;
4475: l_lot_expiration_date DATE;
4476:
4477: BEGIN

Line 4567: mtl_material_transactions mmt

4563: FROM gme_batch_header_vw bh,
4564: mtl_parameters mp,
4565: gme_material_details bl,
4566: mtl_system_items_vl msi,
4567: mtl_material_transactions mmt
4568: where mmt.transaction_set_id = p_txn_header_id AND
4569: bh.batch_id = mmt.TRANSACTION_SOURCE_ID AND
4570: bl.material_detail_id = mmt.TRX_SOURCE_LINE_ID AND
4571: mmt.organization_id = mp.organization_id AND