APPS.GME_MOBILE_TXN dependencies on MTL_MATERIAL_TRANSACTIONS

Line 640: FROM mtl_material_transactions

636:
637: CURSOR Get_Agg_Txn IS
638: SELECT ABS(SUM (NVL(primary_quantity,0))),
639: ABS(SUM (NVL(secondary_transaction_quantity,0)))
640: FROM mtl_material_transactions
641: WHERE organization_id = p_org_id
642: AND transaction_source_id = p_batch_id
643: AND trx_source_line_id = p_material_detail_id
644: AND transaction_source_type_id = gme_common_pvt.g_txn_source_type;

Line 706: FROM mtl_material_transactions m,

702: OPEN x_txn_cursor FOR
703: SELECT m.revision,lot_number,
704: ABS(SUM (NVL(l.primary_quantity,0))),
705: ABS(SUM (NVL(l.secondary_transaction_quantity,0)))
706: FROM mtl_material_transactions m,
707: mtl_transaction_lot_numbers l
708: WHERE l.transaction_id = m.transaction_id
709: AND lot_number = NVL(p_lot_number, l.lot_number)
710: AND m.organization_id = p_org_id

Line 754: FROM mtl_material_transactions

750: IS
751: CURSOR Get_Agg_Txn IS
752: SELECT ABS(SUM (NVL(primary_quantity,0))),
753: ABS(SUM (NVL(secondary_transaction_quantity,0)))
754: FROM mtl_material_transactions
755: WHERE organization_id = p_org_id
756: AND transaction_source_id = p_batch_id
757: AND trx_source_line_id = p_material_detail_id
758: AND transaction_source_type_id = gme_common_pvt.g_txn_source_type

Line 841: FROM mtl_material_transactions m,

837: m.reason_id,
838: l.concatenated_segments,
839: TO_CHAR(transaction_date, l_date_format),
840: revision
841: FROM mtl_material_transactions m,
842: wms_item_locations_kfv l
843: WHERE trx_source_line_id = NVL(p_material_detail_id, trx_source_line_id)
844: AND transaction_source_id = p_batch_id
845: AND transaction_type_id = l_txn_type_id

Line 3357: FROM mtl_material_transactions m,

3353: m.reason_id,
3354: lc.concatenated_segments,
3355: TO_CHAR(m.transaction_date, l_date_format),
3356: revision
3357: FROM mtl_material_transactions m,
3358: mtl_transaction_lot_numbers l,
3359: wms_item_locations_kfv lc
3360: WHERE l.transaction_id = m.transaction_id
3361: AND l.lot_number = NVL(p_lot_number, l.lot_number)

Line 3436: FROM mtl_material_transactions m,

3432: m.reason_id,
3433: lc.concatenated_segments,
3434: TO_CHAR(m.transaction_date, l_date_format),
3435: revision
3436: FROM mtl_material_transactions m,
3437: mtl_transaction_lot_numbers l,
3438: wms_item_locations_kfv lc
3439: WHERE l.transaction_id = m.transaction_id
3440: AND l.lot_number = NVL(p_lot_number, l.lot_number)

Line 4343: l_mmtt_txn_rec MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE;

4339:
4340: l_mti_txn_tbl INV_CALCULATE_EXP_DATE.MTI_TAB;
4341: l_mti_txn_rec MTL_TRANSACTIONS_INTERFACE%ROWTYPE;
4342: l_mtli_txn_rec MTL_TRANSACTION_LOTS_INTERFACE%ROWTYPE;
4343: l_mmtt_txn_rec MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE;
4344: l_mtlt_txn_rec MTL_TRANSACTION_LOTS_TEMP%ROWTYPE;
4345: l_lot_expiration_date DATE;
4346:
4347: BEGIN