[Home] [Help]
396: l_requisition_line_id,
397: l_parentorg_process_org, l_logicalorg_process_org,
398: l_logicalorg_ou_id, l_parentorg_currency,
399: l_transfer_price
400: FROM mtl_material_transactions_temp mmtt,
401: mtl_parameters parentorg, mtl_parameters logicalorg,
402: cst_organization_definitions cod, cst_organization_definitions codx
403: WHERE mmtt.transaction_temp_id = p_transaction_temp_id
404: AND parentorg.organization_id = mmtt.organization_id
542:
543: l_transfer_price := round(l_curr_rate * l_transfer_price, l_ext_precision);
544: END IF;
545:
546: INSERT INTO mtl_material_transactions
547: (TRANSACTION_ID,
548: ORGANIZATION_ID,
549: INVENTORY_ITEM_ID,
550: REVISION,
670: l_transfer_price,
671: DECODE(l_logicalorg_process_org, 'Y', 'N', NULL), -- opm_costed_flag
672: MMT.SHIPMENT_NUMBER -- Bug 6411640
673: FROM
674: mtl_material_transactions mmt,
675: fnd_currencies curr -- Bug 5349860: OPM INVCONV: umoogala 11-Jul-2006
676: WHERE mmt.transaction_id = p_transaction_id
677: AND curr.currency_code(+) = mmt.currency_code;
678:
803: -- transaction flow exists and get the transaction flow header_id, therefore we don't
804: -- need to check transaction flow for logical PO receipt
805: SELECT transaction_source_type_id, transaction_action_id
806: INTO l_transaction_source_type_id, l_transaction_action_id
807: FROM mtl_material_transactions
808: WHERE transaction_id = p_transaction_id;
809:
810: IF (l_debug = 1) THEN
811: print_debug('transaction_source_type_id = ' || l_transaction_source_type_id, 9);
874: l_item_id,
875: l_transaction_date
876: FROM hr_organization_information hoi,
877: oe_order_lines_all oola,
878: mtl_material_transactions mmt
879: WHERE mmt.transaction_id = p_transaction_id
880: AND mmt.trx_source_line_id = oola.line_id
881: AND oola.ship_from_org_id = hoi.organization_id
882: AND hoi.org_information_context = 'Accounting Information';
996: --since selling ou is the same as shipping ou
997: -- update the physical sales order with so_issue_acct_type as
998: -- 2 deferred cogs
999: BEGIN
1000: UPDATE mtl_material_transactions
1001: SET so_issue_account_type =2
1002: WHERE transaction_id = p_transaction_id;
1003: EXCEPTION
1004: WHEN no_data_found THEN
1166: l_mtl_trx_tbl(1).INTERCOMPANY_PRICING_OPTION,
1167: l_mtl_trx_tbl(1).LPN_ID,
1168: l_mtl_trx_tbl(1).parent_transaction_id,
1169: l_defer_logical_trx_flag
1170: FROM mtl_material_transactions
1171: WHERE transaction_id = p_transaction_id;
1172:
1173: IF (l_logical_trx_type_code = G_LOGTRXCODE_RMASOISSUE) THEN
1174: l_mtl_trx_tbl(1).trx_flow_header_id := l_header_id;
1236: print_debug('create_logical_transactions returns success', 9);
1237: END IF;
1238: --deferred cogs change
1239: --when old acct than stamp cogs for multiple OU's.
1240: UPDATE mtl_material_transactions
1241: SET so_issue_account_type = 2--defcogs
1242: WHERE transaction_id = p_transaction_id;
1243: IF (SQL%ROWCOUNT = 0) THEN
1244: IF (l_debug = 1) THEN
1256: ' with trx_flow_header_id = ' || l_header_id, 9);
1257: END IF;
1258: --deferred cogs change
1259: --when old acct than stamp cogs for multiple OU's.
1260: UPDATE mtl_material_transactions
1261: SET trx_flow_header_id = l_header_id,
1262: so_issue_account_type = 1--cogs
1263: WHERE transaction_id = p_transaction_id;
1264: IF (SQL%ROWCOUNT = 0) THEN
1307: | Procedure : CREATE_LOGICAL_TRANSACTIONS |
1308: | |
1309: | Description : The create_logical_transactions API will be a public API that will |
1310: | be called from within Oracle Inventory and other modules that would|
1311: | like to insert records into mtl_material_transactions table as part|
1312: | part of a logical shipment or a logical receipt transaction or a |
1313: | retroactive price change transaction. |
1314: | The following transactions may trigger such as insert: |
1315: | 1. Sales order issue transaction tied to a transaction flow |
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;
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;
1837: print_debug('Update MMT with header_id = ' || p_trx_flow_header_id, 9);
1838: END IF;
1839: -- Bug:3426281. Have to update the MMT record with the header id
1840: l_progress := 190;
1841: UPDATE mtl_material_transactions
1842: SET logical_transactions_created = 2,
1843: invoiced_flag = NULL,
1844: trx_flow_header_id = p_trx_flow_header_id
1845: WHERE transaction_id = p_mtl_trx_tbl(1).transaction_id;
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;
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;
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
3228: print_debug('update MMT of trx_id = ' || p_mtl_trx_tbl(1).transaction_id
3229: || ' with parent trx id and trx batch id = '
3230: || p_mtl_trx_tbl(1).transaction_id, 9);
3231: END IF;
3232: UPDATE mtl_material_transactions
3233: SET parent_transaction_id = p_mtl_trx_tbl(1).transaction_id,
3234: transaction_batch_id = p_mtl_trx_tbl(1).transaction_id,
3235: logical_transactions_created = 1,
3236: logical_transaction = 1,
3289: print_debug('update MMT of trx_id = ' || p_mtl_trx_tbl(1).transaction_id
3290: || ' with parent trx id and trx batch id = '
3291: || p_mtl_trx_tbl(1).transaction_id, 9);
3292: END IF;
3293: UPDATE mtl_material_transactions
3294: SET parent_transaction_id = p_mtl_trx_tbl(1).transaction_id,
3295: transaction_batch_id = p_mtl_trx_tbl(1).transaction_id,
3296: trx_flow_header_id = p_trx_flow_header_id,
3297: logical_transactions_created = 1,
3420: -- so that the index on transaction_date will be used. The start and
3421: -- end dates are mandatory. So, no need for the NVL.
3422: CURSOR deferred_transactions IS
3423: SELECT transaction_id FROM
3424: mtl_material_transactions
3425: WHERE
3426: logical_transactions_created = 2
3427: AND transaction_date BETWEEN
3428: fnd_date.canonical_to_date(p_start_date)
3453: SAVEPOINT create_log_txn;
3454:
3455: BEGIN
3456:
3457: UPDATE mtl_material_transactions
3458: SET logical_transactions_created = 1
3459: WHERE
3460: transaction_id = l_txn_rec.transaction_id;
3461:
3517: |
3518: |
3519: | Description : This API will deletermine if a current accounting
3520: | period that is being closed has any transactions in
3521: | mtl_material_transactions table that has any deferred
3522: | transactions that have not been costed,and if it
3523: | belongs to a transaction flow where the orgs operatinh
3524: | unit is one of the intermediate nodes and so, will
3525: | prevent the user from cosing the accounting period.
3592: l_init_msg_lst VARCHAR2(1) := NVL(p_init_msg_lst, G_FALSE);
3593:
3594: CURSOR deferred_mmt_records IS
3595: SELECT trx_flow_header_id, transaction_date FROM
3596: mtl_material_transactions mmt WHERE costed_flag = 'N' AND
3597: logical_transactions_created = 2;
3598:
3599: BEGIN
3600:
3770:
3771: BEGIN
3772: SELECT COUNT(1) into l_count
3773: FROM
3774: mtl_material_transactions mmt,
3775: mtl_transaction_flow_headers mtfh,
3776: mtl_transaction_flow_lines mtfl
3777: WHERE (mmt.transaction_date BETWEEN
3778: l_period_start_date AND l_period_end_date) AND
3982:
3983: --bulk insert into mmt.
3984:
3985:
3986: INSERT INTO mtl_material_transactions
3987: (TRANSACTION_ID,
3988: ORGANIZATION_ID,
3989: INVENTORY_ITEM_ID,
3990: REVISION,
4144: l_requisition_line_id BINARY_INTEGER;
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;
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;
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;
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;
4155: l_snd_txn_uom mtl_material_transactions.transaction_uom%TYPE;
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;
4155: l_snd_txn_uom mtl_material_transactions.transaction_uom%TYPE;
4156: l_snd_pri_qty mtl_material_transactions.primary_quantity%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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
4168: l_transaction_uom mtl_material_transactions.transaction_uom%TYPE;
4169: l_item_id mtl_material_transactions.inventory_item_id%TYPE;
4170:
4171: l_currency_code mtl_material_transactions.currency_code%TYPE;
4172: l_owner_currency_code mtl_material_transactions.currency_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;
4168: l_transaction_uom mtl_material_transactions.transaction_uom%TYPE;
4169: l_item_id mtl_material_transactions.inventory_item_id%TYPE;
4170:
4171: l_currency_code mtl_material_transactions.currency_code%TYPE;
4172: l_owner_currency_code mtl_material_transactions.currency_code%TYPE;
4173: -- l_snd_ou_id BINARY_INTEGER;
4167: l_secondary_default_ind mtl_system_items_b.secondary_default_ind%TYPE;
4168: l_transaction_uom mtl_material_transactions.transaction_uom%TYPE;
4169: l_item_id mtl_material_transactions.inventory_item_id%TYPE;
4170:
4171: l_currency_code mtl_material_transactions.currency_code%TYPE;
4172: l_owner_currency_code mtl_material_transactions.currency_code%TYPE;
4173: -- l_snd_ou_id BINARY_INTEGER;
4174: -- l_snd_sob_id BINARY_INTEGER;
4175: l_ou_id BINARY_INTEGER;
4168: l_transaction_uom mtl_material_transactions.transaction_uom%TYPE;
4169: l_item_id mtl_material_transactions.inventory_item_id%TYPE;
4170:
4171: l_currency_code mtl_material_transactions.currency_code%TYPE;
4172: l_owner_currency_code mtl_material_transactions.currency_code%TYPE;
4173: -- l_snd_ou_id BINARY_INTEGER;
4174: -- l_snd_sob_id BINARY_INTEGER;
4175: l_ou_id BINARY_INTEGER;
4176: l_sob_id BINARY_INTEGER;
4208: e_uom_conversion_error EXCEPTION;
4209: e_currency_conversion_error EXCEPTION;
4210:
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;
4209: e_currency_conversion_error EXCEPTION;
4210:
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:
4210:
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;
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;
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;
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;
4221: l_pick_strategy_id mtl_material_transactions.pick_strategy_id%TYPE;
4222: l_pick_rule_id mtl_material_transactions.pick_rule_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;
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;
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;
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;
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;
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;
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;
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:
4219: l_picking_line_id mtl_material_transactions.picking_line_id%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;
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:
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;
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;
4230: l_currency_conversion_rate mtl_material_transactions.currency_conversion_rate%TYPE;
4231: l_currency_conversion_type mtl_material_transactions.currency_conversion_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;
4230: l_currency_conversion_rate mtl_material_transactions.currency_conversion_rate%TYPE;
4231: l_currency_conversion_type mtl_material_transactions.currency_conversion_type%TYPE;
4232: l_currency_conversion_date mtl_material_transactions.currency_conversion_date%TYPE;
4233:
4226:
4227: l_invoiced_flag mtl_material_transactions.invoiced_flag%TYPE;
4228:
4229: l_snd_currency_code mtl_material_transactions.currency_code%TYPE;
4230: l_currency_conversion_rate mtl_material_transactions.currency_conversion_rate%TYPE;
4231: l_currency_conversion_type mtl_material_transactions.currency_conversion_type%TYPE;
4232: l_currency_conversion_date mtl_material_transactions.currency_conversion_date%TYPE;
4233:
4234: l_intercompany_currency_code mtl_material_transactions.intercompany_currency_code%TYPE;
4227: l_invoiced_flag mtl_material_transactions.invoiced_flag%TYPE;
4228:
4229: l_snd_currency_code mtl_material_transactions.currency_code%TYPE;
4230: l_currency_conversion_rate mtl_material_transactions.currency_conversion_rate%TYPE;
4231: l_currency_conversion_type mtl_material_transactions.currency_conversion_type%TYPE;
4232: l_currency_conversion_date mtl_material_transactions.currency_conversion_date%TYPE;
4233:
4234: l_intercompany_currency_code mtl_material_transactions.intercompany_currency_code%TYPE;
4235: l_intercompany_cost mtl_material_transactions.intercompany_cost%TYPE;
4228:
4229: l_snd_currency_code mtl_material_transactions.currency_code%TYPE;
4230: l_currency_conversion_rate mtl_material_transactions.currency_conversion_rate%TYPE;
4231: l_currency_conversion_type mtl_material_transactions.currency_conversion_type%TYPE;
4232: l_currency_conversion_date mtl_material_transactions.currency_conversion_date%TYPE;
4233:
4234: l_intercompany_currency_code mtl_material_transactions.intercompany_currency_code%TYPE;
4235: l_intercompany_cost mtl_material_transactions.intercompany_cost%TYPE;
4236: l_intercompany_pricing_option mtl_material_transactions.intercompany_pricing_option%TYPE;
4230: l_currency_conversion_rate mtl_material_transactions.currency_conversion_rate%TYPE;
4231: l_currency_conversion_type mtl_material_transactions.currency_conversion_type%TYPE;
4232: l_currency_conversion_date mtl_material_transactions.currency_conversion_date%TYPE;
4233:
4234: l_intercompany_currency_code mtl_material_transactions.intercompany_currency_code%TYPE;
4235: l_intercompany_cost mtl_material_transactions.intercompany_cost%TYPE;
4236: l_intercompany_pricing_option mtl_material_transactions.intercompany_pricing_option%TYPE;
4237:
4238: -- End Bug 5018698
4231: l_currency_conversion_type mtl_material_transactions.currency_conversion_type%TYPE;
4232: l_currency_conversion_date mtl_material_transactions.currency_conversion_date%TYPE;
4233:
4234: l_intercompany_currency_code mtl_material_transactions.intercompany_currency_code%TYPE;
4235: l_intercompany_cost mtl_material_transactions.intercompany_cost%TYPE;
4236: l_intercompany_pricing_option mtl_material_transactions.intercompany_pricing_option%TYPE;
4237:
4238: -- End Bug 5018698
4239:
4232: l_currency_conversion_date mtl_material_transactions.currency_conversion_date%TYPE;
4233:
4234: l_intercompany_currency_code mtl_material_transactions.intercompany_currency_code%TYPE;
4235: l_intercompany_cost mtl_material_transactions.intercompany_cost%TYPE;
4236: l_intercompany_pricing_option mtl_material_transactions.intercompany_pricing_option%TYPE;
4237:
4238: -- End Bug 5018698
4239:
4240: l_snd_trp_cost mtl_material_transactions.transportation_cost%TYPE;
4236: l_intercompany_pricing_option mtl_material_transactions.intercompany_pricing_option%TYPE;
4237:
4238: -- End Bug 5018698
4239:
4240: l_snd_trp_cost mtl_material_transactions.transportation_cost%TYPE;
4241:
4242: CURSOR c_process_flag(p_organization_id BINARY_INTEGER)
4243: IS
4244: SELECT NVL(mp.process_enabled_flag,'N')
4297: l_xfer_cost_group_id, l_cost_group_id, -- yes, we've to flip CGs
4298: l_transaction_qty, l_transaction_uom,
4299: l_transfer_price, l_transportation_cost,
4300: l_xfer_transaction_id, l_pri_uom
4301: FROM mtl_material_transactions mmt, mtl_system_items_b msi
4302: WHERE mmt.transaction_id = p_transaction_id
4303: AND mmt.inventory_item_id = msi.inventory_item_id
4304: AND mmt.organization_id = msi.organization_id
4305: ;
4510: l_currency_conversion_type, l_currency_conversion_date,
4511: l_intercompany_currency_code, l_intercompany_cost,
4512: l_intercompany_pricing_option,
4513: l_ship_to_location_id, l_snd_trp_cost
4514: FROM mtl_material_transactions mmt, mtl_system_items_b msi
4515: WHERE mmt.transaction_id = l_xfer_transaction_id
4516: AND mmt.inventory_item_id = msi.inventory_item_id
4517: AND mmt.organization_id = msi.organization_id
4518: ;
4577: ol.source_document_id -- Requisition_header_id
4578: -- requisition_line_id = ol.source_document_line_id
4579: INTO
4580: l_transaction_source_id
4581: FROM mtl_material_transactions mmt, oe_order_lines_all ol
4582: WHERE mmt.transaction_id = p_transaction_id
4583: AND ol.line_id = mmt.trx_source_line_id
4584: ;
4585: ELSE
4884: END IF;
4885: /** we have all values, insert into MMT */
4886:
4887: l_stmt_num := 170;
4888: INSERT INTO mtl_material_transactions
4889: (TRANSACTION_ID,
4890: ORGANIZATION_ID,
4891: INVENTORY_ITEM_ID,
4892: REVISION,
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,
5055: l_pick_rule_id,
5056: l_pick_slip_date,
5057: mmt.intransit_account, -- Bug 5018698
5058: l_so_issue_account_type
5059: FROM mtl_material_transactions mmt
5060: WHERE mmt.transaction_id = p_transaction_id;
5061:
5062: x_return_status := g_ret_sts_success;
5063: