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.INV_LOGICAL_TRANSACTIONS_PUB dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 1617: SELECT mtl_material_transactions_s.nextval

1613: l_mtl_trx_tbl(i).costed_flag := 'N';
1614: l_mtl_trx_tbl(i).invoiced_flag := null;
1615:
1616: -- populate the transaction id to the record
1617: SELECT mtl_material_transactions_s.nextval
1618: INTO l_mtl_trx_tbl(i).transaction_id
1619: FROM DUAL;
1620:
1621: l_mtl_trx_tbl(i).transaction_batch_id := l_mtl_trx_tbl(1).transaction_id;

Line 1669: SELECT mtl_material_transactions_s.nextval

1665: IF (l_defer_logical_trx = G_NOT_DEFER_LOGICAL_TRX) THEN -- not defer
1666: FOR i in 1..l_mtl_trx_tbl.COUNT LOOP
1667: l_progress := 120;
1668: -- populate transaction id
1669: SELECT mtl_material_transactions_s.nextval
1670: INTO l_mtl_trx_tbl(i).transaction_id
1671: FROM dual;
1672:
1673: l_progress := 130;

Line 2094: SELECT mtl_material_transactions_s.nextval

2090: l_mtl_trx_tbl(1).invoiced_flag := null;
2091: l_mtl_trx_tbl(1).parent_transaction_flag := 1;
2092:
2093: l_progress := 270;
2094: SELECT mtl_material_transactions_s.nextval
2095: INTO l_mtl_trx_tbl(1).transaction_id
2096: FROM dual;
2097:
2098: l_mtl_trx_tbl(1).transaction_batch_id := l_mtl_trx_tbl(1).transaction_id;

Line 2176: SELECT mtl_material_transactions_s.nextval

2172: RAISE FND_API.G_EXC_ERROR;
2173: END IF;
2174:
2175: l_progress := 300;
2176: SELECT mtl_material_transactions_s.nextval
2177: INTO l_mtl_trx_tbl(1).transaction_id
2178: FROM dual;
2179:
2180: l_mtl_trx_tbl(1).parent_transaction_id := p_mtl_trx_tbl(1).transaction_id;

Line 2830: SELECT mtl_material_transactions_s.nextval

2826: -- populate the transaction id of the records
2827: FOR i in 1..l_mtl_trx_tbl.COUNT LOOP
2828: -- populate transaction id
2829: l_progress := 400;
2830: SELECT mtl_material_transactions_s.nextval
2831: INTO l_mtl_trx_tbl(i).transaction_id
2832: FROM dual;
2833:
2834: -- populate the columns which has same value for all types of records

Line 4149: l_sec_uom_code mtl_material_transactions.secondary_uom_code%TYPE;

4145: l_expenditure_type VARCHAR2(240);
4146: l_distribution_account_id BINARY_INTEGER;
4147: l_curr_conversion_rate NUMBER;
4148: l_pri_uom_code mtl_material_transactions.transaction_uom%TYPE;
4149: l_sec_uom_code mtl_material_transactions.secondary_uom_code%TYPE;
4150: l_sec_qty mtl_material_transactions.secondary_transaction_quantity%TYPE;
4151: l_transfer_price mtl_material_transactions.transfer_price%TYPE;
4152: l_transportation_cost mtl_material_transactions.transportation_cost%TYPE;
4153: l_xfer_transaction_id mtl_material_transactions.transfer_transaction_id%TYPE;

Line 4150: l_sec_qty mtl_material_transactions.secondary_transaction_quantity%TYPE;

4146: l_distribution_account_id BINARY_INTEGER;
4147: l_curr_conversion_rate NUMBER;
4148: l_pri_uom_code mtl_material_transactions.transaction_uom%TYPE;
4149: l_sec_uom_code mtl_material_transactions.secondary_uom_code%TYPE;
4150: l_sec_qty mtl_material_transactions.secondary_transaction_quantity%TYPE;
4151: l_transfer_price mtl_material_transactions.transfer_price%TYPE;
4152: l_transportation_cost mtl_material_transactions.transportation_cost%TYPE;
4153: l_xfer_transaction_id mtl_material_transactions.transfer_transaction_id%TYPE;
4154: l_snd_txn_qty mtl_material_transactions.transaction_quantity%TYPE;

Line 4158: l_snd_subinv mtl_material_transactions.subinventory_code%TYPE;

4154: l_snd_txn_qty mtl_material_transactions.transaction_quantity%TYPE;
4155: l_snd_txn_uom mtl_material_transactions.transaction_uom%TYPE;
4156: l_snd_pri_qty mtl_material_transactions.primary_quantity%TYPE;
4157: l_snd_pri_uom mtl_system_items_b.primary_uom_code%TYPE;
4158: l_snd_subinv mtl_material_transactions.subinventory_code%TYPE;
4159: l_pri_qty mtl_material_transactions.primary_quantity%TYPE;
4160: l_pri_uom mtl_system_items_b.primary_uom_code%TYPE;
4161: l_owner_pri_uom mtl_system_items_b.primary_uom_code%TYPE;
4162: l_pri_uom_rate NUMBER;

Line 4163: l_snd_sec_qty mtl_material_transactions.secondary_transaction_quantity%TYPE;

4159: l_pri_qty mtl_material_transactions.primary_quantity%TYPE;
4160: l_pri_uom mtl_system_items_b.primary_uom_code%TYPE;
4161: l_owner_pri_uom mtl_system_items_b.primary_uom_code%TYPE;
4162: l_pri_uom_rate NUMBER;
4163: l_snd_sec_qty mtl_material_transactions.secondary_transaction_quantity%TYPE;
4164: l_snd_sec_uom mtl_system_items_b.secondary_uom_code%TYPE;
4165: l_sec_uom mtl_system_items_b.secondary_uom_code%TYPE;
4166: l_tracking_quantity_ind mtl_system_items_b.tracking_quantity_ind%TYPE;
4167: l_secondary_default_ind mtl_system_items_b.secondary_default_ind%TYPE;

Line 4215: l_source_code mtl_material_transactions.source_code%TYPE;

4211: -- Bug 5018698: Following columns have been added.
4212: l_transaction_source_id mtl_material_transactions.transaction_source_id%TYPE;
4213: l_transaction_source_name mtl_material_transactions.transaction_source_name%TYPE;
4214: l_trx_source_line_id mtl_material_transactions.trx_source_line_id%TYPE;
4215: l_source_code mtl_material_transactions.source_code%TYPE;
4216: l_source_line_id mtl_material_transactions.source_line_id%TYPE;
4217:
4218: l_trx_source_delivery_id mtl_material_transactions.trx_source_delivery_id%TYPE;
4219: l_picking_line_id mtl_material_transactions.picking_line_id%TYPE;

Line 4216: l_source_line_id mtl_material_transactions.source_line_id%TYPE;

4212: l_transaction_source_id mtl_material_transactions.transaction_source_id%TYPE;
4213: l_transaction_source_name mtl_material_transactions.transaction_source_name%TYPE;
4214: l_trx_source_line_id mtl_material_transactions.trx_source_line_id%TYPE;
4215: l_source_code mtl_material_transactions.source_code%TYPE;
4216: l_source_line_id mtl_material_transactions.source_line_id%TYPE;
4217:
4218: l_trx_source_delivery_id mtl_material_transactions.trx_source_delivery_id%TYPE;
4219: l_picking_line_id mtl_material_transactions.picking_line_id%TYPE;
4220: l_pick_slip_number mtl_material_transactions.pick_slip_number%TYPE;

Line 4224: l_so_issue_account_type mtl_material_transactions.so_issue_account_type%TYPE;

4220: l_pick_slip_number mtl_material_transactions.pick_slip_number%TYPE;
4221: l_pick_strategy_id mtl_material_transactions.pick_strategy_id%TYPE;
4222: l_pick_rule_id mtl_material_transactions.pick_rule_id%TYPE;
4223: l_pick_slip_date mtl_material_transactions.pick_slip_date%TYPE;
4224: l_so_issue_account_type mtl_material_transactions.so_issue_account_type%TYPE;
4225: l_ship_to_location_id mtl_material_transactions.ship_to_location_id%TYPE;
4226:
4227: l_invoiced_flag mtl_material_transactions.invoiced_flag%TYPE;
4228:

Line 4225: l_ship_to_location_id mtl_material_transactions.ship_to_location_id%TYPE;

4221: l_pick_strategy_id mtl_material_transactions.pick_strategy_id%TYPE;
4222: l_pick_rule_id mtl_material_transactions.pick_rule_id%TYPE;
4223: l_pick_slip_date mtl_material_transactions.pick_slip_date%TYPE;
4224: l_so_issue_account_type mtl_material_transactions.so_issue_account_type%TYPE;
4225: l_ship_to_location_id mtl_material_transactions.ship_to_location_id%TYPE;
4226:
4227: l_invoiced_flag mtl_material_transactions.invoiced_flag%TYPE;
4228:
4229: l_snd_currency_code mtl_material_transactions.currency_code%TYPE;

Line 4973: mtl_material_transactions_s.nextval, -- transaction_id

4969: INTRANSIT_ACCOUNT, -- Bug 5018698
4970: SO_ISSUE_ACCOUNT_TYPE
4971: )
4972: SELECT
4973: mtl_material_transactions_s.nextval, -- transaction_id
4974: l_owner_org_id, -- organization_id
4975: mmt.inventory_item_id,
4976: mmt.revision,
4977: decode(mmt.fob_point, G_FOB_RECEIVING, l_snd_subinv,