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 1634: SELECT mtl_material_transactions_s.nextval

1630: l_mtl_trx_tbl(i).costed_flag := 'N';
1631: l_mtl_trx_tbl(i).invoiced_flag := null;
1632:
1633: -- populate the transaction id to the record
1634: SELECT mtl_material_transactions_s.nextval
1635: INTO l_mtl_trx_tbl(i).transaction_id
1636: FROM DUAL;
1637:
1638: l_mtl_trx_tbl(i).transaction_batch_id := l_mtl_trx_tbl(1).transaction_id;

Line 1686: SELECT mtl_material_transactions_s.nextval

1682: IF (l_defer_logical_trx = G_NOT_DEFER_LOGICAL_TRX) THEN -- not defer
1683: FOR i in 1..l_mtl_trx_tbl.COUNT LOOP
1684: l_progress := 120;
1685: -- populate transaction id
1686: SELECT mtl_material_transactions_s.nextval
1687: INTO l_mtl_trx_tbl(i).transaction_id
1688: FROM dual;
1689:
1690: l_progress := 130;

Line 2111: SELECT mtl_material_transactions_s.nextval

2107: l_mtl_trx_tbl(1).invoiced_flag := null;
2108: l_mtl_trx_tbl(1).parent_transaction_flag := 1;
2109:
2110: l_progress := 270;
2111: SELECT mtl_material_transactions_s.nextval
2112: INTO l_mtl_trx_tbl(1).transaction_id
2113: FROM dual;
2114:
2115: l_mtl_trx_tbl(1).transaction_batch_id := l_mtl_trx_tbl(1).transaction_id;

Line 2193: SELECT mtl_material_transactions_s.nextval

2189: RAISE FND_API.G_EXC_ERROR;
2190: END IF;
2191:
2192: l_progress := 300;
2193: SELECT mtl_material_transactions_s.nextval
2194: INTO l_mtl_trx_tbl(1).transaction_id
2195: FROM dual;
2196:
2197: l_mtl_trx_tbl(1).parent_transaction_id := p_mtl_trx_tbl(1).transaction_id;

Line 2875: SELECT mtl_material_transactions_s.nextval

2871: -- populate the transaction id of the records
2872: FOR i in 1..l_mtl_trx_tbl.COUNT LOOP
2873: -- populate transaction id
2874: l_progress := 400;
2875: SELECT mtl_material_transactions_s.nextval
2876: INTO l_mtl_trx_tbl(i).transaction_id
2877: FROM dual;
2878:
2879: -- populate the columns which has same value for all types of records

Line 4236: l_sec_uom_code mtl_material_transactions.secondary_uom_code%TYPE;

4232: l_expenditure_type VARCHAR2(240);
4233: l_distribution_account_id BINARY_INTEGER;
4234: l_curr_conversion_rate NUMBER;
4235: l_pri_uom_code mtl_material_transactions.transaction_uom%TYPE;
4236: l_sec_uom_code mtl_material_transactions.secondary_uom_code%TYPE;
4237: l_sec_qty mtl_material_transactions.secondary_transaction_quantity%TYPE;
4238: l_transfer_price mtl_material_transactions.transfer_price%TYPE;
4239: l_transportation_cost mtl_material_transactions.transportation_cost%TYPE;
4240: l_xfer_transaction_id mtl_material_transactions.transfer_transaction_id%TYPE;

Line 4237: l_sec_qty mtl_material_transactions.secondary_transaction_quantity%TYPE;

4233: l_distribution_account_id BINARY_INTEGER;
4234: l_curr_conversion_rate NUMBER;
4235: l_pri_uom_code mtl_material_transactions.transaction_uom%TYPE;
4236: l_sec_uom_code mtl_material_transactions.secondary_uom_code%TYPE;
4237: l_sec_qty mtl_material_transactions.secondary_transaction_quantity%TYPE;
4238: l_transfer_price mtl_material_transactions.transfer_price%TYPE;
4239: l_transportation_cost mtl_material_transactions.transportation_cost%TYPE;
4240: l_xfer_transaction_id mtl_material_transactions.transfer_transaction_id%TYPE;
4241: l_snd_txn_qty mtl_material_transactions.transaction_quantity%TYPE;

Line 4245: l_snd_subinv mtl_material_transactions.subinventory_code%TYPE;

4241: l_snd_txn_qty mtl_material_transactions.transaction_quantity%TYPE;
4242: l_snd_txn_uom mtl_material_transactions.transaction_uom%TYPE;
4243: l_snd_pri_qty mtl_material_transactions.primary_quantity%TYPE;
4244: l_snd_pri_uom mtl_system_items_b.primary_uom_code%TYPE;
4245: l_snd_subinv mtl_material_transactions.subinventory_code%TYPE;
4246: l_pri_qty mtl_material_transactions.primary_quantity%TYPE;
4247: l_pri_uom mtl_system_items_b.primary_uom_code%TYPE;
4248: l_owner_pri_uom mtl_system_items_b.primary_uom_code%TYPE;
4249: l_pri_uom_rate NUMBER;

Line 4250: l_snd_sec_qty mtl_material_transactions.secondary_transaction_quantity%TYPE;

4246: l_pri_qty mtl_material_transactions.primary_quantity%TYPE;
4247: l_pri_uom mtl_system_items_b.primary_uom_code%TYPE;
4248: l_owner_pri_uom mtl_system_items_b.primary_uom_code%TYPE;
4249: l_pri_uom_rate NUMBER;
4250: l_snd_sec_qty mtl_material_transactions.secondary_transaction_quantity%TYPE;
4251: l_snd_sec_uom mtl_system_items_b.secondary_uom_code%TYPE;
4252: l_sec_uom mtl_system_items_b.secondary_uom_code%TYPE;
4253: l_tracking_quantity_ind mtl_system_items_b.tracking_quantity_ind%TYPE;
4254: l_secondary_default_ind mtl_system_items_b.secondary_default_ind%TYPE;

Line 4302: l_source_code mtl_material_transactions.source_code%TYPE;

4298: -- Bug 5018698: Following columns have been added.
4299: l_transaction_source_id mtl_material_transactions.transaction_source_id%TYPE;
4300: l_transaction_source_name mtl_material_transactions.transaction_source_name%TYPE;
4301: l_trx_source_line_id mtl_material_transactions.trx_source_line_id%TYPE;
4302: l_source_code mtl_material_transactions.source_code%TYPE;
4303: l_source_line_id mtl_material_transactions.source_line_id%TYPE;
4304:
4305: l_trx_source_delivery_id mtl_material_transactions.trx_source_delivery_id%TYPE;
4306: l_picking_line_id mtl_material_transactions.picking_line_id%TYPE;

Line 4303: l_source_line_id mtl_material_transactions.source_line_id%TYPE;

4299: l_transaction_source_id mtl_material_transactions.transaction_source_id%TYPE;
4300: l_transaction_source_name mtl_material_transactions.transaction_source_name%TYPE;
4301: l_trx_source_line_id mtl_material_transactions.trx_source_line_id%TYPE;
4302: l_source_code mtl_material_transactions.source_code%TYPE;
4303: l_source_line_id mtl_material_transactions.source_line_id%TYPE;
4304:
4305: l_trx_source_delivery_id mtl_material_transactions.trx_source_delivery_id%TYPE;
4306: l_picking_line_id mtl_material_transactions.picking_line_id%TYPE;
4307: l_pick_slip_number mtl_material_transactions.pick_slip_number%TYPE;

Line 4311: l_so_issue_account_type mtl_material_transactions.so_issue_account_type%TYPE;

4307: l_pick_slip_number mtl_material_transactions.pick_slip_number%TYPE;
4308: l_pick_strategy_id mtl_material_transactions.pick_strategy_id%TYPE;
4309: l_pick_rule_id mtl_material_transactions.pick_rule_id%TYPE;
4310: l_pick_slip_date mtl_material_transactions.pick_slip_date%TYPE;
4311: l_so_issue_account_type mtl_material_transactions.so_issue_account_type%TYPE;
4312: l_ship_to_location_id mtl_material_transactions.ship_to_location_id%TYPE;
4313:
4314: l_invoiced_flag mtl_material_transactions.invoiced_flag%TYPE;
4315:

Line 4312: l_ship_to_location_id mtl_material_transactions.ship_to_location_id%TYPE;

4308: l_pick_strategy_id mtl_material_transactions.pick_strategy_id%TYPE;
4309: l_pick_rule_id mtl_material_transactions.pick_rule_id%TYPE;
4310: l_pick_slip_date mtl_material_transactions.pick_slip_date%TYPE;
4311: l_so_issue_account_type mtl_material_transactions.so_issue_account_type%TYPE;
4312: l_ship_to_location_id mtl_material_transactions.ship_to_location_id%TYPE;
4313:
4314: l_invoiced_flag mtl_material_transactions.invoiced_flag%TYPE;
4315:
4316: l_snd_currency_code mtl_material_transactions.currency_code%TYPE;

Line 5061: mtl_material_transactions_s.nextval, -- transaction_id

5057: INTRANSIT_ACCOUNT, -- Bug 5018698
5058: SO_ISSUE_ACCOUNT_TYPE
5059: )
5060: SELECT
5061: mtl_material_transactions_s.nextval, -- transaction_id
5062: l_owner_org_id, -- organization_id
5063: mmt.inventory_item_id,
5064: mmt.revision,
5065: decode(mmt.fob_point, G_FOB_RECEIVING, l_snd_subinv,