[Home] [Help]
412: l_requisition_line_id,
413: l_parentorg_process_org, l_logicalorg_process_org,
414: l_logicalorg_ou_id, l_parentorg_currency,
415: l_transfer_price
416: FROM mtl_material_transactions_temp mmtt,
417: mtl_parameters parentorg, mtl_parameters logicalorg,
418: cst_organization_definitions cod, cst_organization_definitions codx
419: WHERE mmtt.transaction_temp_id = p_transaction_temp_id
420: AND parentorg.organization_id = mmtt.organization_id
558:
559: l_transfer_price := round(l_curr_rate * l_transfer_price, l_ext_precision);
560: END IF;
561:
562: INSERT INTO mtl_material_transactions
563: (TRANSACTION_ID,
564: ORGANIZATION_ID,
565: INVENTORY_ITEM_ID,
566: REVISION,
686: l_transfer_price,
687: DECODE(l_logicalorg_process_org, 'Y', 'N', NULL), -- opm_costed_flag
688: MMT.SHIPMENT_NUMBER -- Bug 6411640
689: FROM
690: mtl_material_transactions mmt,
691: fnd_currencies curr -- Bug 5349860: OPM INVCONV: umoogala 11-Jul-2006
692: WHERE mmt.transaction_id = p_transaction_id
693: AND curr.currency_code(+) = mmt.currency_code;
694:
819: -- transaction flow exists and get the transaction flow header_id, therefore we don't
820: -- need to check transaction flow for logical PO receipt
821: SELECT transaction_source_type_id, transaction_action_id
822: INTO l_transaction_source_type_id, l_transaction_action_id
823: FROM mtl_material_transactions
824: WHERE transaction_id = p_transaction_id;
825:
826: IF (l_debug = 1) THEN
827: print_debug('transaction_source_type_id = ' || l_transaction_source_type_id, 9);
890: l_item_id,
891: l_transaction_date
892: FROM hr_organization_information hoi,
893: oe_order_lines_all oola,
894: mtl_material_transactions mmt
895: WHERE mmt.transaction_id = p_transaction_id
896: AND mmt.trx_source_line_id = oola.line_id
897: AND oola.ship_from_org_id = hoi.organization_id
898: AND hoi.org_information_context = 'Accounting Information';
1012: --since selling ou is the same as shipping ou
1013: -- update the physical sales order with so_issue_acct_type as
1014: -- 2 deferred cogs
1015: BEGIN
1016: UPDATE mtl_material_transactions
1017: SET so_issue_account_type =2
1018: WHERE transaction_id = p_transaction_id;
1019: EXCEPTION
1020: WHEN no_data_found THEN
1182: l_mtl_trx_tbl(1).INTERCOMPANY_PRICING_OPTION,
1183: l_mtl_trx_tbl(1).LPN_ID,
1184: l_mtl_trx_tbl(1).parent_transaction_id,
1185: l_defer_logical_trx_flag
1186: FROM mtl_material_transactions
1187: WHERE transaction_id = p_transaction_id;
1188:
1189: IF (l_logical_trx_type_code = G_LOGTRXCODE_RMASOISSUE) THEN
1190: l_mtl_trx_tbl(1).trx_flow_header_id := l_header_id;
1252: print_debug('create_logical_transactions returns success', 9);
1253: END IF;
1254: --deferred cogs change
1255: --when old acct than stamp cogs for multiple OU's.
1256: UPDATE mtl_material_transactions
1257: SET so_issue_account_type = 2--defcogs
1258: WHERE transaction_id = p_transaction_id;
1259: IF (SQL%ROWCOUNT = 0) THEN
1260: IF (l_debug = 1) THEN
1272: ' with trx_flow_header_id = ' || l_header_id, 9);
1273: END IF;
1274: --deferred cogs change
1275: --when old acct than stamp cogs for multiple OU's.
1276: UPDATE mtl_material_transactions
1277: SET trx_flow_header_id = l_header_id,
1278: so_issue_account_type = 1--cogs
1279: WHERE transaction_id = p_transaction_id;
1280: IF (SQL%ROWCOUNT = 0) THEN
1323: | Procedure : CREATE_LOGICAL_TRANSACTIONS |
1324: | |
1325: | Description : The create_logical_transactions API will be a public API that will |
1326: | be called from within Oracle Inventory and other modules that would|
1327: | like to insert records into mtl_material_transactions table as part|
1328: | part of a logical shipment or a logical receipt transaction or a |
1329: | retroactive price change transaction. |
1330: | The following transactions may trigger such as insert: |
1331: | 1. Sales order issue transaction tied to a transaction flow |
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;
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;
1854: print_debug('Update MMT with header_id = ' || p_trx_flow_header_id, 9);
1855: END IF;
1856: -- Bug:3426281. Have to update the MMT record with the header id
1857: l_progress := 190;
1858: UPDATE mtl_material_transactions
1859: SET logical_transactions_created = 2,
1860: invoiced_flag = NULL,
1861: trx_flow_header_id = p_trx_flow_header_id
1862: WHERE transaction_id = p_mtl_trx_tbl(1).transaction_id;
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;
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;
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
3315: print_debug('update MMT of trx_id = ' || p_mtl_trx_tbl(1).transaction_id
3316: || ' with parent trx id and trx batch id = '
3317: || p_mtl_trx_tbl(1).transaction_id, 9);
3318: END IF;
3319: UPDATE mtl_material_transactions
3320: SET parent_transaction_id = p_mtl_trx_tbl(1).transaction_id,
3321: transaction_batch_id = p_mtl_trx_tbl(1).transaction_id,
3322: logical_transactions_created = 1,
3323: logical_transaction = 1,
3376: print_debug('update MMT of trx_id = ' || p_mtl_trx_tbl(1).transaction_id
3377: || ' with parent trx id and trx batch id = '
3378: || p_mtl_trx_tbl(1).transaction_id, 9);
3379: END IF;
3380: UPDATE mtl_material_transactions
3381: SET parent_transaction_id = p_mtl_trx_tbl(1).transaction_id,
3382: transaction_batch_id = p_mtl_trx_tbl(1).transaction_id,
3383: trx_flow_header_id = p_trx_flow_header_id,
3384: logical_transactions_created = 1,
3507: -- so that the index on transaction_date will be used. The start and
3508: -- end dates are mandatory. So, no need for the NVL.
3509: CURSOR deferred_transactions IS
3510: SELECT transaction_id FROM
3511: mtl_material_transactions
3512: WHERE
3513: logical_transactions_created = 2
3514: AND transaction_date BETWEEN
3515: fnd_date.canonical_to_date(p_start_date)
3540: SAVEPOINT create_log_txn;
3541:
3542: BEGIN
3543:
3544: UPDATE mtl_material_transactions
3545: SET logical_transactions_created = 1
3546: WHERE
3547: transaction_id = l_txn_rec.transaction_id;
3548:
3604: |
3605: |
3606: | Description : This API will deletermine if a current accounting
3607: | period that is being closed has any transactions in
3608: | mtl_material_transactions table that has any deferred
3609: | transactions that have not been costed,and if it
3610: | belongs to a transaction flow where the orgs operatinh
3611: | unit is one of the intermediate nodes and so, will
3612: | prevent the user from cosing the accounting period.
3679: l_init_msg_lst VARCHAR2(1) := NVL(p_init_msg_lst, G_FALSE);
3680:
3681: CURSOR deferred_mmt_records IS
3682: SELECT trx_flow_header_id, transaction_date FROM
3683: mtl_material_transactions mmt WHERE costed_flag = 'N' AND
3684: logical_transactions_created = 2;
3685:
3686: BEGIN
3687:
3857:
3858: BEGIN
3859: SELECT COUNT(1) into l_count
3860: FROM
3861: mtl_material_transactions mmt,
3862: mtl_transaction_flow_headers mtfh,
3863: mtl_transaction_flow_lines mtfl
3864: WHERE (mmt.transaction_date BETWEEN
3865: l_period_start_date AND l_period_end_date) AND
4069:
4070: --bulk insert into mmt.
4071:
4072:
4073: INSERT INTO mtl_material_transactions
4074: (TRANSACTION_ID,
4075: ORGANIZATION_ID,
4076: INVENTORY_ITEM_ID,
4077: REVISION,
4231: l_requisition_line_id BINARY_INTEGER;
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;
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;
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;
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;
4242: l_snd_txn_uom mtl_material_transactions.transaction_uom%TYPE;
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;
4242: l_snd_txn_uom mtl_material_transactions.transaction_uom%TYPE;
4243: l_snd_pri_qty mtl_material_transactions.primary_quantity%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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
4255: l_transaction_uom mtl_material_transactions.transaction_uom%TYPE;
4256: l_item_id mtl_material_transactions.inventory_item_id%TYPE;
4257:
4258: l_currency_code mtl_material_transactions.currency_code%TYPE;
4259: l_owner_currency_code mtl_material_transactions.currency_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;
4255: l_transaction_uom mtl_material_transactions.transaction_uom%TYPE;
4256: l_item_id mtl_material_transactions.inventory_item_id%TYPE;
4257:
4258: l_currency_code mtl_material_transactions.currency_code%TYPE;
4259: l_owner_currency_code mtl_material_transactions.currency_code%TYPE;
4260: -- l_snd_ou_id BINARY_INTEGER;
4254: l_secondary_default_ind mtl_system_items_b.secondary_default_ind%TYPE;
4255: l_transaction_uom mtl_material_transactions.transaction_uom%TYPE;
4256: l_item_id mtl_material_transactions.inventory_item_id%TYPE;
4257:
4258: l_currency_code mtl_material_transactions.currency_code%TYPE;
4259: l_owner_currency_code mtl_material_transactions.currency_code%TYPE;
4260: -- l_snd_ou_id BINARY_INTEGER;
4261: -- l_snd_sob_id BINARY_INTEGER;
4262: l_ou_id BINARY_INTEGER;
4255: l_transaction_uom mtl_material_transactions.transaction_uom%TYPE;
4256: l_item_id mtl_material_transactions.inventory_item_id%TYPE;
4257:
4258: l_currency_code mtl_material_transactions.currency_code%TYPE;
4259: l_owner_currency_code mtl_material_transactions.currency_code%TYPE;
4260: -- l_snd_ou_id BINARY_INTEGER;
4261: -- l_snd_sob_id BINARY_INTEGER;
4262: l_ou_id BINARY_INTEGER;
4263: l_sob_id BINARY_INTEGER;
4295: e_uom_conversion_error EXCEPTION;
4296: e_currency_conversion_error EXCEPTION;
4297:
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;
4296: e_currency_conversion_error EXCEPTION;
4297:
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:
4297:
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;
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;
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;
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;
4308: l_pick_strategy_id mtl_material_transactions.pick_strategy_id%TYPE;
4309: l_pick_rule_id mtl_material_transactions.pick_rule_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;
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;
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;
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;
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;
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;
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;
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:
4306: l_picking_line_id mtl_material_transactions.picking_line_id%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;
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:
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;
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;
4317: l_currency_conversion_rate mtl_material_transactions.currency_conversion_rate%TYPE;
4318: l_currency_conversion_type mtl_material_transactions.currency_conversion_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;
4317: l_currency_conversion_rate mtl_material_transactions.currency_conversion_rate%TYPE;
4318: l_currency_conversion_type mtl_material_transactions.currency_conversion_type%TYPE;
4319: l_currency_conversion_date mtl_material_transactions.currency_conversion_date%TYPE;
4320:
4313:
4314: l_invoiced_flag mtl_material_transactions.invoiced_flag%TYPE;
4315:
4316: l_snd_currency_code mtl_material_transactions.currency_code%TYPE;
4317: l_currency_conversion_rate mtl_material_transactions.currency_conversion_rate%TYPE;
4318: l_currency_conversion_type mtl_material_transactions.currency_conversion_type%TYPE;
4319: l_currency_conversion_date mtl_material_transactions.currency_conversion_date%TYPE;
4320:
4321: l_intercompany_currency_code mtl_material_transactions.intercompany_currency_code%TYPE;
4314: l_invoiced_flag mtl_material_transactions.invoiced_flag%TYPE;
4315:
4316: l_snd_currency_code mtl_material_transactions.currency_code%TYPE;
4317: l_currency_conversion_rate mtl_material_transactions.currency_conversion_rate%TYPE;
4318: l_currency_conversion_type mtl_material_transactions.currency_conversion_type%TYPE;
4319: l_currency_conversion_date mtl_material_transactions.currency_conversion_date%TYPE;
4320:
4321: l_intercompany_currency_code mtl_material_transactions.intercompany_currency_code%TYPE;
4322: l_intercompany_cost mtl_material_transactions.intercompany_cost%TYPE;
4315:
4316: l_snd_currency_code mtl_material_transactions.currency_code%TYPE;
4317: l_currency_conversion_rate mtl_material_transactions.currency_conversion_rate%TYPE;
4318: l_currency_conversion_type mtl_material_transactions.currency_conversion_type%TYPE;
4319: l_currency_conversion_date mtl_material_transactions.currency_conversion_date%TYPE;
4320:
4321: l_intercompany_currency_code mtl_material_transactions.intercompany_currency_code%TYPE;
4322: l_intercompany_cost mtl_material_transactions.intercompany_cost%TYPE;
4323: l_intercompany_pricing_option mtl_material_transactions.intercompany_pricing_option%TYPE;
4317: l_currency_conversion_rate mtl_material_transactions.currency_conversion_rate%TYPE;
4318: l_currency_conversion_type mtl_material_transactions.currency_conversion_type%TYPE;
4319: l_currency_conversion_date mtl_material_transactions.currency_conversion_date%TYPE;
4320:
4321: l_intercompany_currency_code mtl_material_transactions.intercompany_currency_code%TYPE;
4322: l_intercompany_cost mtl_material_transactions.intercompany_cost%TYPE;
4323: l_intercompany_pricing_option mtl_material_transactions.intercompany_pricing_option%TYPE;
4324:
4325: -- End Bug 5018698
4318: l_currency_conversion_type mtl_material_transactions.currency_conversion_type%TYPE;
4319: l_currency_conversion_date mtl_material_transactions.currency_conversion_date%TYPE;
4320:
4321: l_intercompany_currency_code mtl_material_transactions.intercompany_currency_code%TYPE;
4322: l_intercompany_cost mtl_material_transactions.intercompany_cost%TYPE;
4323: l_intercompany_pricing_option mtl_material_transactions.intercompany_pricing_option%TYPE;
4324:
4325: -- End Bug 5018698
4326:
4319: l_currency_conversion_date mtl_material_transactions.currency_conversion_date%TYPE;
4320:
4321: l_intercompany_currency_code mtl_material_transactions.intercompany_currency_code%TYPE;
4322: l_intercompany_cost mtl_material_transactions.intercompany_cost%TYPE;
4323: l_intercompany_pricing_option mtl_material_transactions.intercompany_pricing_option%TYPE;
4324:
4325: -- End Bug 5018698
4326:
4327: l_snd_trp_cost mtl_material_transactions.transportation_cost%TYPE;
4323: l_intercompany_pricing_option mtl_material_transactions.intercompany_pricing_option%TYPE;
4324:
4325: -- End Bug 5018698
4326:
4327: l_snd_trp_cost mtl_material_transactions.transportation_cost%TYPE;
4328:
4329: CURSOR c_process_flag(p_organization_id BINARY_INTEGER)
4330: IS
4331: SELECT NVL(mp.process_enabled_flag,'N')
4384: l_xfer_cost_group_id, l_cost_group_id, -- yes, we've to flip CGs
4385: l_transaction_qty, l_transaction_uom,
4386: l_transfer_price, l_transportation_cost,
4387: l_xfer_transaction_id, l_pri_uom
4388: FROM mtl_material_transactions mmt, mtl_system_items_b msi
4389: WHERE mmt.transaction_id = p_transaction_id
4390: AND mmt.inventory_item_id = msi.inventory_item_id
4391: AND mmt.organization_id = msi.organization_id
4392: ;
4597: l_currency_conversion_type, l_currency_conversion_date,
4598: l_intercompany_currency_code, l_intercompany_cost,
4599: l_intercompany_pricing_option,
4600: l_ship_to_location_id, l_snd_trp_cost
4601: FROM mtl_material_transactions mmt, mtl_system_items_b msi
4602: WHERE mmt.transaction_id = l_xfer_transaction_id
4603: AND mmt.inventory_item_id = msi.inventory_item_id
4604: AND mmt.organization_id = msi.organization_id
4605: ;
4664: ol.source_document_id -- Requisition_header_id
4665: -- requisition_line_id = ol.source_document_line_id
4666: INTO
4667: l_transaction_source_id
4668: FROM mtl_material_transactions mmt, oe_order_lines_all ol
4669: WHERE mmt.transaction_id = p_transaction_id
4670: AND ol.line_id = mmt.trx_source_line_id
4671: ;
4672: ELSE
4972: END IF;
4973: /** we have all values, insert into MMT */
4974:
4975: l_stmt_num := 170;
4976: INSERT INTO mtl_material_transactions
4977: (TRANSACTION_ID,
4978: ORGANIZATION_ID,
4979: INVENTORY_ITEM_ID,
4980: REVISION,
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,
5143: l_pick_rule_id,
5144: l_pick_slip_date,
5145: mmt.intransit_account, -- Bug 5018698
5146: l_so_issue_account_type
5147: FROM mtl_material_transactions mmt
5148: WHERE mmt.transaction_id = p_transaction_id;
5149:
5150: x_return_status := g_ret_sts_success;
5151: