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.CSTPAPBR dependencies on MTL_MATERIAL_TRANSACTIONS

Line 9: | MTL_MATERIAL_TRANSACTIONS or WIP_TRANSACTIONS depending on the type of txn |

5:
6: /*============================================================================+
7: | This procedure is called by the Accounting Package for the Accounting Lib. |
8: | It first gets the details of the transaction from either |
9: | MTL_MATERIAL_TRANSACTIONS or WIP_TRANSACTIONS depending on the type of txn |
10: | that is being processed. The appropriate procedure is then called to create |
11: | the accounting entry lines in the form of a PL/SQL table. |
12: |============================================================================*/
13:

Line 182: mtl_material_transactions mmt,

178: l_ae_txn_rec.om_line_id,
179: l_ae_txn_rec.cogs_percentage,
180: l_ae_txn_rec.expense_account_id
181: FROM
182: mtl_material_transactions mmt,
183: mtl_system_items msi
184: WHERE
185: mmt.inventory_item_id = msi.inventory_item_id AND
186: mmt.organization_id = msi.organization_id AND

Line 647: FROM mtl_material_transactions mmt,mtl_interorg_parameters mip

643:
644: l_stmt_num := 12;
645: SELECT nvl(mmt.fob_point,mip.fob_point)
646: INTO l_fob_point
647: FROM mtl_material_transactions mmt,mtl_interorg_parameters mip
648: WHERE mmt.transaction_id = i_ae_txn_rec.transaction_id
649: AND mip.from_organization_id = i_ae_txn_rec.xfer_organization_id
650: AND mip.to_organization_id = i_ae_txn_rec.organization_id;
651:

Line 746: from mtl_material_transactions

742: procedure */
743:
744: select nvl(logical_transaction, 2)
745: into l_logical_transaction
746: from mtl_material_transactions
747: where transaction_id = i_ae_txn_rec.transaction_id;
748:
749: -- Calling procedures, depending on transaction_source_type_id and transaction_action_id.
750: -- --------------------------------------------------------------------------------------

Line 1747: FROM mtl_material_transactions mmt,mtl_interorg_parameters mip

1743: /* Get FOB Point */
1744: IF (i_ae_txn_rec.txn_action_id IN (12,21,15,22)) THEN -- INVCONV sikhanna
1745: SELECT nvl(mmt.fob_point,mip.fob_point)
1746: INTO l_fob_point
1747: FROM mtl_material_transactions mmt,mtl_interorg_parameters mip
1748: WHERE mmt.transaction_id = i_ae_txn_rec.transaction_id
1749: AND mip.from_organization_id = decode(i_ae_txn_rec.txn_action_id,
1750: 21,i_ae_txn_rec.organization_id,
1751: 22,i_ae_txn_rec.organization_id, -- INVCONV sikhanna

Line 1982: FROM mtl_material_transactions

1978:
1979: l_stmt_num := 43;
1980: SELECT transfer_transaction_id
1981: INTO l_txfr_txn_id
1982: FROM mtl_material_transactions
1983: WHERE transaction_id = i_ae_txn_rec.transaction_id;
1984:
1985: END IF;
1986:

Line 2003: FROM mtl_material_transactions

1999: 3, decode(sign(i_ae_txn_rec.primary_quantity),
2000: 1, transfer_organization_id,
2001: organization_id),
2002: NULL)
2003: FROM mtl_material_transactions
2004: WHERE transaction_id = i_ae_txn_rec.transaction_id);
2005: EXCEPTION
2006: WHEN no_data_found THEN
2007: l_shipping_cg_id := -1;

Line 2262: FROM mtl_material_transactions MMT

2258: IF (i_ae_txn_rec.txn_action_id = 15) THEN
2259:
2260: SELECT NVL(mmt.transfer_price,0)
2261: INTO l_transfer_price
2262: FROM mtl_material_transactions MMT
2263: WHERE MMT.transaction_id = i_ae_txn_rec.transaction_id;
2264:
2265: ELSE
2266:

Line 2269: FROM mtl_material_transactions MMT

2265: ELSE
2266:
2267: SELECT NVL(mmt.transfer_price,0) * l_conv_rate
2268: INTO l_transfer_price
2269: FROM mtl_material_transactions MMT
2270: WHERE MMT.transaction_id = i_ae_txn_rec.transaction_id;
2271:
2272: END IF;
2273:

Line 2526: mtl_material_transactions mmt

2522: l_io_freight_acct,
2523: l_io_txfr_cr_acct,
2524: l_io_txfr_var_acct
2525: FROM mtl_interorg_parameters mip,
2526: mtl_material_transactions mmt
2527: WHERE mip.from_organization_id = i_ae_txn_rec.organization_id
2528: AND mip.to_organization_id = i_ae_txn_rec.xfer_organization_id
2529: AND mmt.transaction_id = i_ae_txn_rec.transaction_id;
2530:

Line 2605: FROM mtl_material_transactions

2601: /* Get transfer credit information */
2602: l_stmt_num := 112;
2603: SELECT nvl(transfer_percentage,0),nvl(transfer_cost,0)
2604: INTO l_txfr_percent,l_txfr_cost
2605: FROM mtl_material_transactions
2606: WHERE transaction_id = i_ae_txn_rec.transaction_id;
2607:
2608: IF (l_txfr_percent <> 0) THEN
2609: l_txfr_credit := (l_txfr_percent * l_pacp_pwac_cost / 100);

Line 2697: FROM mtl_material_transactions

2693: /* Get transfer credit information */
2694: l_stmt_num := 117;
2695: SELECT nvl(transfer_percentage,0),nvl(transfer_cost,0)
2696: INTO l_txfr_percent,l_txfr_cost
2697: FROM mtl_material_transactions
2698: WHERE transaction_id = i_ae_txn_rec.transaction_id;
2699:
2700: IF (l_txfr_percent <> 0) THEN
2701: l_txfr_credit := (l_txfr_percent * l_prev_period_pwac_cost / 100);

Line 2847: FROM mtl_material_transactions

2843: l_stmt_num := 145;
2844:
2845: SELECT nvl(transfer_percentage,0),nvl(transfer_cost,0)
2846: INTO l_txfr_percent,l_txfr_cost
2847: FROM mtl_material_transactions
2848: WHERE transaction_id = i_ae_txn_rec.transaction_id;
2849:
2850: IF (l_txfr_percent <> 0) THEN
2851: l_txfr_credit := (l_txfr_percent * (l_perp_ship_value)/ (100 * abs(i_ae_txn_rec.primary_quantity)));

Line 2995: FROM mtl_interorg_parameters mip,mtl_material_transactions mmt

2991: l_io_freight_acct,
2992: l_io_txfr_var_acct,
2993: l_txfr_cost, -- transfer price
2994: l_trp_cost -- transportation cost
2995: FROM mtl_interorg_parameters mip,mtl_material_transactions mmt
2996: WHERE mip.from_organization_id = i_ae_txn_rec.organization_id
2997: AND mip.to_organization_id = i_ae_txn_rec.xfer_organization_id
2998: AND mmt.transaction_id = i_ae_txn_rec.transaction_id;
2999:

Line 3088: mtl_material_transactions mmt

3084: mmt.transportation_dist_account
3085: INTO l_io_pay_acct,
3086: l_io_freight_acct
3087: FROM mtl_interorg_parameters mip,
3088: mtl_material_transactions mmt
3089: WHERE mip.from_organization_id = i_ae_txn_rec.organization_id
3090: AND mip.to_organization_id = i_ae_txn_rec.xfer_organization_id
3091: AND mmt.transaction_id = i_ae_txn_rec.transaction_id;
3092:

Line 3133: FROM mtl_material_transactions

3129: l_stmt_num := 215;
3130:
3131: SELECT nvl(transportation_cost,0) * l_conv_rate /* convert from shipping org currency to receiving org currency */
3132: INTO l_trp_cost
3133: FROM mtl_material_transactions
3134: WHERE transaction_id = i_ae_txn_rec.transaction_id;
3135:
3136: l_ae_line_rec.transaction_value := l_trp_cost;
3137: l_ae_line_rec.account := l_io_freight_acct;

Line 3340: FROM mtl_interorg_parameters mip,mtl_material_transactions mmt

3336: INTO l_io_rcv_acct,
3337: l_io_freight_acct,
3338: l_io_txfr_cr_acct,
3339: l_io_txfr_var_acct
3340: FROM mtl_interorg_parameters mip,mtl_material_transactions mmt
3341: WHERE mip.from_organization_id = i_ae_txn_rec.organization_id
3342: AND mip.to_organization_id = i_ae_txn_rec.xfer_organization_id
3343: AND mmt.transaction_id = i_ae_txn_rec.transaction_id;
3344:

Line 3424: FROM mtl_material_transactions

3420: nvl(transportation_cost,0)
3421: INTO l_txfr_percent,
3422: l_txfr_cost,
3423: l_trp_cost
3424: FROM mtl_material_transactions
3425: WHERE transaction_id = i_ae_txn_rec.transaction_id;
3426:
3427: IF (l_txfr_percent <> 0) THEN
3428: l_txfr_credit := (l_txfr_percent * l_pacp_pwac_cost / 100);

Line 3553: FROM mtl_material_transactions

3549: nvl(transportation_cost,0)
3550: INTO l_txfr_percent,
3551: l_txfr_cost,
3552: l_trp_cost
3553: FROM mtl_material_transactions
3554: WHERE transaction_id = i_ae_txn_rec.transaction_id;
3555:
3556: IF (l_txfr_percent <> 0) THEN
3557: l_txfr_credit := (l_txfr_percent * l_prev_period_pwac_cost / 100);

Line 3724: FROM mtl_interorg_parameters mip,mtl_material_transactions mmt

3720: INTO l_io_rcv_acct,
3721: l_io_freight_acct,
3722: l_io_txfr_cr_acct,
3723: l_io_txfr_var_acct
3724: FROM mtl_interorg_parameters mip,mtl_material_transactions mmt
3725: WHERE mip.from_organization_id = i_ae_txn_rec.organization_id -- INVCONV condition is opposite
3726: AND mip.to_organization_id = i_ae_txn_rec.xfer_organization_id
3727: AND mmt.transaction_id = i_ae_txn_rec.transaction_id;
3728:

Line 3739: FROM mtl_material_transactions mmt

3735: SELECT nvl(transfer_price,0),
3736: nvl(transportation_cost,0)
3737: INTO l_txfr_cost, -- transfer price
3738: l_trp_cost -- transportation cost
3739: FROM mtl_material_transactions mmt
3740: WHERE mmt.transaction_id = i_ae_txn_rec.transaction_id;
3741:
3742: l_stmt_num := 328;
3743: /* create debit entries */

Line 3863: FROM mtl_material_transactions

3859: l_stmt_num := 342;
3860:
3861: SELECT nvl(transfer_percentage,0),nvl(transfer_cost,0),nvl(transportation_cost,0)
3862: INTO l_txfr_percent,l_txfr_cost,l_trp_cost
3863: FROM mtl_material_transactions
3864: WHERE transaction_id = i_ae_txn_rec.transaction_id;
3865:
3866: IF (l_txfr_percent <> 0) THEN
3867: l_txfr_credit := (l_txfr_percent * l_perp_ship_value) / (100 * abs(i_ae_txn_rec.primary_quantity));

Line 4184: FROM mtl_material_transactions

4180: /* Credit Intercompany Accrual Account */
4181:
4182: SELECT nvl(expense_account_id,-1)
4183: INTO l_accrual_account
4184: FROM mtl_material_transactions
4185: WHERE transaction_id = i_ae_txn_rec.transaction_id;
4186:
4187: l_stmt_num := 396;
4188: -- Bug 5573993 - Derive the Intercompany account to break dependency on perpetual

Line 4238: FROM mtl_material_transactions MMT

4234: l_stmt_num := 401;
4235:
4236: SELECT NVL(mmt.transfer_price,0)
4237: INTO l_transfer_price
4238: FROM mtl_material_transactions MMT
4239: WHERE MMT.transaction_id = i_ae_txn_rec.transaction_id;
4240:
4241: IF g_debug_flag = 'Y' THEN
4242: fnd_file.put_line(fnd_file.log,l_api_name || ': ' || l_stmt_num ||

Line 4580: FROM mtl_interorg_parameters mip,mtl_material_transactions mmt

4576: INTO l_io_rcv_acct,
4577: l_io_freight_acct,
4578: l_io_txfr_cr_acct,
4579: l_io_txfr_var_acct
4580: FROM mtl_interorg_parameters mip,mtl_material_transactions mmt
4581: WHERE mip.from_organization_id = i_ae_txn_rec.xfer_organization_id
4582: AND mip.to_organization_id = i_ae_txn_rec.organization_id
4583: AND mmt.transaction_id = i_ae_txn_rec.transaction_id;
4584:

Line 4700: FROM mtl_material_transactions

4696:
4697: l_stmt_num := 492;
4698: SELECT nvl(transfer_percentage,0),nvl(transfer_cost,0),nvl(transportation_cost,0),primary_quantity
4699: INTO l_txfr_percent,l_txfr_cost,l_trp_cost,l_txfr_txn_qty
4700: FROM mtl_material_transactions
4701: WHERE transaction_id = l_txfr_txn_id;
4702:
4703: IF (l_txfr_percent <> 0) THEN
4704: l_txfr_credit := (l_txfr_percent * l_pacp_pwac_cost / 100);

Line 4823: FROM mtl_material_transactions

4819: l_stmt_num := 505;
4820:
4821: SELECT nvl(transfer_percentage,0),nvl(transfer_cost,0),nvl(transportation_cost,0),primary_quantity
4822: INTO l_txfr_percent,l_txfr_cost,l_trp_cost,l_txfr_txn_qty
4823: FROM mtl_material_transactions
4824: WHERE transaction_id = l_txfr_txn_id;
4825:
4826: IF (l_txfr_percent <> 0) THEN
4827: l_txfr_credit := (l_txfr_percent * l_prev_period_pwac_cost / 100);

Line 4994: FROM mtl_material_transactions

4990: We also need the shipment transaction quantity since this is the quantity we'll
4991: need to divide by to get the unit transfer and transportation cost. */
4992: SELECT nvl(transfer_percentage,0),nvl(transfer_cost,0),nvl(transportation_cost,0),primary_quantity
4993: INTO l_txfr_percent,l_txfr_cost,l_trp_cost,l_txfr_txn_qty
4994: FROM mtl_material_transactions
4995: WHERE transaction_id = l_txfr_txn_id;
4996:
4997: IF (l_txfr_percent <> 0) THEN
4998: l_txfr_credit := (l_txfr_percent * (l_perp_ship_value)/ (100 * abs(l_txfr_txn_qty)));

Line 5335: mtl_material_transactions mmt

5331: mmt.transportation_dist_account
5332: INTO l_io_pay_acct,
5333: l_io_freight_acct
5334: FROM mtl_interorg_parameters mip,
5335: mtl_material_transactions mmt
5336: WHERE mip.from_organization_id = i_ae_txn_rec.xfer_organization_id
5337: AND mip.to_organization_id = i_ae_txn_rec.organization_id
5338: AND mmt.transaction_id = i_ae_txn_rec.transaction_id;
5339:

Line 5382: FROM mtl_material_transactions mmt

5378: SELECT nvl(transfer_price,0),
5379: nvl(transportation_cost,0)
5380: INTO l_txfr_cost, -- transfer price
5381: l_trp_cost -- transportation cost
5382: FROM mtl_material_transactions mmt
5383: WHERE mmt.transaction_id = i_ae_txn_rec.transaction_id;
5384:
5385: /* Credit freight account */
5386:

Line 5511: FROM mtl_interorg_parameters mip,mtl_material_transactions mmt

5507: INTO l_io_rcv_acct,
5508: l_io_freight_acct,
5509: l_io_txfr_cr_acct,
5510: l_io_txfr_var_acct
5511: FROM mtl_interorg_parameters mip,mtl_material_transactions mmt
5512: WHERE mip.from_organization_id = i_ae_txn_rec.organization_id -- INVCONV condition is opposite
5513: AND mip.to_organization_id = i_ae_txn_rec.xfer_organization_id
5514: AND mmt.transaction_id = i_ae_txn_rec.transaction_id;
5515:

Line 5526: FROM mtl_material_transactions mmt

5522: SELECT nvl(transfer_price,0),
5523: nvl(transportation_cost,0)
5524: INTO l_txfr_cost, -- transfer price
5525: l_trp_cost -- transportation cost
5526: FROM mtl_material_transactions mmt
5527: WHERE mmt.transaction_id = i_ae_txn_rec.transaction_id;
5528:
5529: l_stmt_num := 655;
5530: /* create debit entries */

Line 6318: from rcv_transactions rt, mtl_material_transactions mmt

6314: Account */
6315:
6316: select nvl(rt.dropship_type_code, 3)
6317: into l_dropship_type_code
6318: from rcv_transactions rt, mtl_material_transactions mmt
6319: where mmt.rcv_transaction_id = rt.transaction_id
6320: and mmt.transaction_id = i_ae_txn_rec.transaction_id;
6321:
6322: if (l_dropship_type_code = 1 or l_dropship_type_code = 2) then

Line 6860: from mtl_material_transactions

6856: --update i_ae_txn_rec.
6857:
6858: select nvl(quantity_adjusted, 0)
6859: into l_qty
6860: from mtl_material_transactions
6861: where transaction_id = i_ae_txn_rec.transaction_id;
6862:
6863: -- Figure out Retroactive price update account.
6864: -- ---------------------------------------------

Line 8966: l_curr_type MTL_MATERIAL_TRANSACTIONS.CURRENCY_CONVERSION_TYPE%TYPE;

8962: l_snd_curr GL_SETS_OF_BOOKS.CURRENCY_CODE%TYPE;
8963: l_rcv_sob_id NUMBER;
8964: l_rcv_coa_id NUMBER;
8965: l_rcv_curr GL_SETS_OF_BOOKS.CURRENCY_CODE%TYPE;
8966: l_curr_type MTL_MATERIAL_TRANSACTIONS.CURRENCY_CONVERSION_TYPE%TYPE;
8967: l_conv_rate NUMBER;
8968: l_conv_date DATE;
8969: l_err_rec CSTPALTY.cst_ae_err_rec_type;
8970: l_from_org NUMBER;

Line 9033: FROM mtl_material_transactions

9029: 3, decode(sign(i_ae_txn_rec.primary_quantity),
9030: 1, transfer_organization_id,
9031: organization_id),
9032: NULL)
9033: FROM mtl_material_transactions
9034: WHERE transaction_id = i_ae_txn_rec.transaction_id);
9035: EXCEPTION
9036: WHEN no_data_found THEN
9037: l_shipping_cg_id := -1;

Line 9101: FROM mtl_material_transactions MMT, oe_order_headers_all OEH, oe_order_lines_all OEL

9097: l_stmt_num := 40;
9098:
9099: SELECT MMT.trx_source_line_id, OEH.header_id, OEH.sold_to_org_id, OEH.order_type_id
9100: INTO l_line_id, l_header_id, l_cust_id, l_order_type
9101: FROM mtl_material_transactions MMT, oe_order_headers_all OEH, oe_order_lines_all OEL
9102: WHERE MMT.transaction_id = i_ae_txn_rec.transaction_id
9103: AND OEL.line_id = MMT.trx_source_line_id
9104: AND OEL.header_id = OEH.header_id;
9105:

Line 9115: FROM mtl_material_transactions MMT, rcv_transactions RT

9111: -- For action id 22, transfer_transaction_id points to receiving txn, not the shipping txn,
9112: -- because it got created after goods are received, so goto else part...
9113: decode(l_pd_txfr_ind, 1, 0, nvl(MMT.transfer_transaction_id, 0))
9114: INTO l_ship_num, l_req_line, l_txf_txn_id
9115: FROM mtl_material_transactions MMT, rcv_transactions RT
9116: WHERE MMT.transaction_id = i_ae_txn_rec.transaction_id
9117: AND RT.transaction_id = MMT.rcv_transaction_id;
9118:
9119:

Line 9126: FROM mtl_material_transactions MMT, oe_order_headers_all OEH, oe_order_lines_all OEL

9122: l_stmt_num := 60;
9123:
9124: SELECT MMT.trx_source_line_id, OEH.header_id, OEH.sold_to_org_id, OEH.order_type_id
9125: INTO l_line_id, l_header_id, l_cust_id, l_order_type
9126: FROM mtl_material_transactions MMT, oe_order_headers_all OEH, oe_order_lines_all OEL
9127: WHERE MMT.transaction_id = i_ae_txn_rec.xfer_transaction_id
9128: AND MMT.trx_source_line_id = OEL.line_id
9129: AND OEL.header_id = OEH.header_id;
9130:

Line 9137: FROM mtl_material_transactions MMT, oe_order_headers_all OEH, oe_order_lines_all OEL

9133: l_stmt_num := 70;
9134:
9135: SELECT MMT.trx_source_line_id, OEH.header_id, OEH.sold_to_org_id, OEH.order_type_id
9136: INTO l_line_id, l_header_id, l_cust_id, l_order_type
9137: FROM mtl_material_transactions MMT, oe_order_headers_all OEH, oe_order_lines_all OEL
9138: WHERE MMT.transaction_action_id = 21
9139: AND MMT.transaction_source_type_id = 8
9140: AND MMT.organization_id = l_from_org
9141: AND MMT.inventory_item_id = i_ae_txn_rec.inventory_item_id

Line 9473: FROM mtl_material_transactions mmt

9469: This cannot be NULL as it is stamped by INV Manager and not
9470: during Cost Processing in CSTPAVCP.Cost_LogicalSOReceipt */
9471: SELECT distribution_account_id
9472: INTO l_mmt_exp_account
9473: FROM mtl_material_transactions mmt
9474: WHERE mmt.transaction_id = i_ae_txn_rec.xfer_transaction_id;
9475:
9476: l_stmt_num := 120;
9477:

Line 9619: mtl_material_transactions mmt

9615: INTO l_io_rcv_acct,
9616: l_io_txfr_cr_acct,
9617: l_io_txfr_var_acct
9618: FROM mtl_interorg_parameters mip,
9619: mtl_material_transactions mmt
9620: WHERE mip.from_organization_id = i_ae_txn_rec.organization_id
9621: AND mip.to_organization_id = i_ae_txn_rec.xfer_organization_id
9622: AND mmt.transaction_id = i_ae_txn_rec.transaction_id;
9623:

Line 9785: mtl_material_transactions mmt

9781: distribution_account_id
9782: INTO l_io_pay_acct,
9783: l_mmt_exp_account
9784: FROM mtl_interorg_parameters mip,
9785: mtl_material_transactions mmt
9786: WHERE mip.from_organization_id = i_ae_txn_rec.xfer_organization_id
9787: AND mip.to_organization_id = i_ae_txn_rec.organization_id
9788: AND mmt.transaction_id = i_ae_txn_rec.transaction_id;
9789:

Line 9939: FROM mtl_interorg_parameters mip,mtl_material_transactions mmt

9935: nvl(mmt.transfer_price,0)
9936: INTO l_io_rcv_acct,
9937: l_io_txfr_var_acct,
9938: l_transfer_price -- transfer price
9939: FROM mtl_interorg_parameters mip,mtl_material_transactions mmt
9940: WHERE mip.from_organization_id = i_ae_txn_rec.organization_id
9941: AND mip.to_organization_id = i_ae_txn_rec.xfer_organization_id
9942: AND mmt.transaction_id = i_ae_txn_rec.transaction_id;
9943:

Line 10071: mtl_material_transactions mmt

10067: INTO l_io_pay_acct,
10068: l_mmt_exp_account,
10069: l_transfer_price -- transfer price
10070: FROM mtl_interorg_parameters mip,
10071: mtl_material_transactions mmt
10072: WHERE mip.from_organization_id = i_ae_txn_rec.xfer_organization_id
10073: AND mip.to_organization_id = i_ae_txn_rec.organization_id
10074: AND mmt.transaction_id = i_ae_txn_rec.transaction_id;
10075:

Line 10243: FROM mtl_material_transactions

10239:
10240: /* Get transfer credit information */
10241: SELECT nvl(transfer_percentage,0),nvl(transfer_cost,0)
10242: INTO l_txfr_percent,l_txfr_cost
10243: FROM mtl_material_transactions
10244: WHERE transaction_id = i_ae_txn_rec.transaction_id;
10245:
10246: l_stmt_num := 110;
10247:

Line 10473: p_transaction_id IN MTL_MATERIAL_TRANSACTIONS.TRANSACTION_ID%TYPE,

10469:
10470:
10471: PROCEDURE CompEncumbrance_IntOrdersExp (
10472: p_api_version IN NUMBER,
10473: p_transaction_id IN MTL_MATERIAL_TRANSACTIONS.TRANSACTION_ID%TYPE,
10474: p_req_line_id IN PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE,
10475: p_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE,
10476: p_organization_id IN MTL_PARAMETERS.ORGANIZATION_ID%TYPE,
10477: p_primary_qty IN MTL_MATERIAL_TRANSACTIONS.PRIMARY_QUANTITY%TYPE,

Line 10477: p_primary_qty IN MTL_MATERIAL_TRANSACTIONS.PRIMARY_QUANTITY%TYPE,

10473: p_transaction_id IN MTL_MATERIAL_TRANSACTIONS.TRANSACTION_ID%TYPE,
10474: p_req_line_id IN PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE,
10475: p_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE,
10476: p_organization_id IN MTL_PARAMETERS.ORGANIZATION_ID%TYPE,
10477: p_primary_qty IN MTL_MATERIAL_TRANSACTIONS.PRIMARY_QUANTITY%TYPE,
10478: p_total_primary_qty IN NUMBER,
10479: x_encumbrance_amount OUT NOCOPY NUMBER,
10480: x_encumbrance_account OUT NOCOPY NUMBER,
10481: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type

Line 10612: p_transaction_id IN MTL_MATERIAL_TRANSACTIONS.TRANSACTION_ID%TYPE,

10608: END CompEncumbrance_IntOrdersExp;
10609:
10610: PROCEDURE CompEncumbrance_IntOrdersExp (
10611: p_api_version IN NUMBER,
10612: p_transaction_id IN MTL_MATERIAL_TRANSACTIONS.TRANSACTION_ID%TYPE,
10613: x_encumbrance_amount OUT NOCOPY NUMBER,
10614: x_encumbrance_account OUT NOCOPY NUMBER,
10615: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
10616: ) IS

Line 10619: l_primary_qty MTL_MATERIAL_TRANSACTIONS.PRIMARY_QUANTITY%TYPE;

10615: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
10616: ) IS
10617:
10618: l_total_primary_qty NUMBER;
10619: l_primary_qty MTL_MATERIAL_TRANSACTIONS.PRIMARY_QUANTITY%TYPE;
10620: l_organization_id MTL_MATERIAL_TRANSACTIONS.ORGANIZATION_ID%TYPE;
10621: l_trx_source_line_id MTL_MATERIAL_TRANSACTIONS.TRX_SOURCE_LINE_ID%TYPE;
10622: l_req_line_id PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE;
10623: l_item_id MTL_MATERIAL_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE;

Line 10620: l_organization_id MTL_MATERIAL_TRANSACTIONS.ORGANIZATION_ID%TYPE;

10616: ) IS
10617:
10618: l_total_primary_qty NUMBER;
10619: l_primary_qty MTL_MATERIAL_TRANSACTIONS.PRIMARY_QUANTITY%TYPE;
10620: l_organization_id MTL_MATERIAL_TRANSACTIONS.ORGANIZATION_ID%TYPE;
10621: l_trx_source_line_id MTL_MATERIAL_TRANSACTIONS.TRX_SOURCE_LINE_ID%TYPE;
10622: l_req_line_id PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE;
10623: l_item_id MTL_MATERIAL_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE;
10624: l_txn_action_id MTL_MATERIAL_TRANSACTIONS.TRANSACTION_ACTION_ID%TYPE;

Line 10621: l_trx_source_line_id MTL_MATERIAL_TRANSACTIONS.TRX_SOURCE_LINE_ID%TYPE;

10617:
10618: l_total_primary_qty NUMBER;
10619: l_primary_qty MTL_MATERIAL_TRANSACTIONS.PRIMARY_QUANTITY%TYPE;
10620: l_organization_id MTL_MATERIAL_TRANSACTIONS.ORGANIZATION_ID%TYPE;
10621: l_trx_source_line_id MTL_MATERIAL_TRANSACTIONS.TRX_SOURCE_LINE_ID%TYPE;
10622: l_req_line_id PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE;
10623: l_item_id MTL_MATERIAL_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE;
10624: l_txn_action_id MTL_MATERIAL_TRANSACTIONS.TRANSACTION_ACTION_ID%TYPE;
10625: l_txn_src_type_id MTL_MATERIAL_TRANSACTIONS.TRANSACTION_SOURCE_TYPE_ID%TYPE;

Line 10623: l_item_id MTL_MATERIAL_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE;

10619: l_primary_qty MTL_MATERIAL_TRANSACTIONS.PRIMARY_QUANTITY%TYPE;
10620: l_organization_id MTL_MATERIAL_TRANSACTIONS.ORGANIZATION_ID%TYPE;
10621: l_trx_source_line_id MTL_MATERIAL_TRANSACTIONS.TRX_SOURCE_LINE_ID%TYPE;
10622: l_req_line_id PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE;
10623: l_item_id MTL_MATERIAL_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE;
10624: l_txn_action_id MTL_MATERIAL_TRANSACTIONS.TRANSACTION_ACTION_ID%TYPE;
10625: l_txn_src_type_id MTL_MATERIAL_TRANSACTIONS.TRANSACTION_SOURCE_TYPE_ID%TYPE;
10626: l_rcv_txn_id MTL_MATERIAL_TRANSACTIONS.RCV_TRANSACTION_ID%TYPE;
10627: l_txn_type_id MTL_MATERIAL_TRANSACTIONS.TRANSACTION_TYPE_ID%TYPE;

Line 10624: l_txn_action_id MTL_MATERIAL_TRANSACTIONS.TRANSACTION_ACTION_ID%TYPE;

10620: l_organization_id MTL_MATERIAL_TRANSACTIONS.ORGANIZATION_ID%TYPE;
10621: l_trx_source_line_id MTL_MATERIAL_TRANSACTIONS.TRX_SOURCE_LINE_ID%TYPE;
10622: l_req_line_id PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE;
10623: l_item_id MTL_MATERIAL_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE;
10624: l_txn_action_id MTL_MATERIAL_TRANSACTIONS.TRANSACTION_ACTION_ID%TYPE;
10625: l_txn_src_type_id MTL_MATERIAL_TRANSACTIONS.TRANSACTION_SOURCE_TYPE_ID%TYPE;
10626: l_rcv_txn_id MTL_MATERIAL_TRANSACTIONS.RCV_TRANSACTION_ID%TYPE;
10627: l_txn_type_id MTL_MATERIAL_TRANSACTIONS.TRANSACTION_TYPE_ID%TYPE;
10628: l_txn_date MTL_MATERIAL_TRANSACTIONS.TRANSACTION_DATE%TYPE;

Line 10625: l_txn_src_type_id MTL_MATERIAL_TRANSACTIONS.TRANSACTION_SOURCE_TYPE_ID%TYPE;

10621: l_trx_source_line_id MTL_MATERIAL_TRANSACTIONS.TRX_SOURCE_LINE_ID%TYPE;
10622: l_req_line_id PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE;
10623: l_item_id MTL_MATERIAL_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE;
10624: l_txn_action_id MTL_MATERIAL_TRANSACTIONS.TRANSACTION_ACTION_ID%TYPE;
10625: l_txn_src_type_id MTL_MATERIAL_TRANSACTIONS.TRANSACTION_SOURCE_TYPE_ID%TYPE;
10626: l_rcv_txn_id MTL_MATERIAL_TRANSACTIONS.RCV_TRANSACTION_ID%TYPE;
10627: l_txn_type_id MTL_MATERIAL_TRANSACTIONS.TRANSACTION_TYPE_ID%TYPE;
10628: l_txn_date MTL_MATERIAL_TRANSACTIONS.TRANSACTION_DATE%TYPE;
10629:

Line 10626: l_rcv_txn_id MTL_MATERIAL_TRANSACTIONS.RCV_TRANSACTION_ID%TYPE;

10622: l_req_line_id PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE;
10623: l_item_id MTL_MATERIAL_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE;
10624: l_txn_action_id MTL_MATERIAL_TRANSACTIONS.TRANSACTION_ACTION_ID%TYPE;
10625: l_txn_src_type_id MTL_MATERIAL_TRANSACTIONS.TRANSACTION_SOURCE_TYPE_ID%TYPE;
10626: l_rcv_txn_id MTL_MATERIAL_TRANSACTIONS.RCV_TRANSACTION_ID%TYPE;
10627: l_txn_type_id MTL_MATERIAL_TRANSACTIONS.TRANSACTION_TYPE_ID%TYPE;
10628: l_txn_date MTL_MATERIAL_TRANSACTIONS.TRANSACTION_DATE%TYPE;
10629:
10630: l_stmt_num NUMBER;

Line 10627: l_txn_type_id MTL_MATERIAL_TRANSACTIONS.TRANSACTION_TYPE_ID%TYPE;

10623: l_item_id MTL_MATERIAL_TRANSACTIONS.INVENTORY_ITEM_ID%TYPE;
10624: l_txn_action_id MTL_MATERIAL_TRANSACTIONS.TRANSACTION_ACTION_ID%TYPE;
10625: l_txn_src_type_id MTL_MATERIAL_TRANSACTIONS.TRANSACTION_SOURCE_TYPE_ID%TYPE;
10626: l_rcv_txn_id MTL_MATERIAL_TRANSACTIONS.RCV_TRANSACTION_ID%TYPE;
10627: l_txn_type_id MTL_MATERIAL_TRANSACTIONS.TRANSACTION_TYPE_ID%TYPE;
10628: l_txn_date MTL_MATERIAL_TRANSACTIONS.TRANSACTION_DATE%TYPE;
10629:
10630: l_stmt_num NUMBER;
10631: l_api_name VARCHAR2(100) := 'CompEncumbrance_IntOrdersExp';

Line 10628: l_txn_date MTL_MATERIAL_TRANSACTIONS.TRANSACTION_DATE%TYPE;

10624: l_txn_action_id MTL_MATERIAL_TRANSACTIONS.TRANSACTION_ACTION_ID%TYPE;
10625: l_txn_src_type_id MTL_MATERIAL_TRANSACTIONS.TRANSACTION_SOURCE_TYPE_ID%TYPE;
10626: l_rcv_txn_id MTL_MATERIAL_TRANSACTIONS.RCV_TRANSACTION_ID%TYPE;
10627: l_txn_type_id MTL_MATERIAL_TRANSACTIONS.TRANSACTION_TYPE_ID%TYPE;
10628: l_txn_date MTL_MATERIAL_TRANSACTIONS.TRANSACTION_DATE%TYPE;
10629:
10630: l_stmt_num NUMBER;
10631: l_api_name VARCHAR2(100) := 'CompEncumbrance_IntOrdersExp';
10632: l_api_version NUMBER := 1.0;

Line 10669: MTL_MATERIAL_TRANSACTIONS mmt

10665: l_txn_type_id,
10666: l_rcv_txn_id,
10667: l_txn_date
10668: FROM
10669: MTL_MATERIAL_TRANSACTIONS mmt
10670: WHERE
10671: transaction_id = p_transaction_id;
10672:
10673: -- Get total received quantity so far just before processing the current receipt transaction

Line 10679: from mtl_material_transactions

10675: -- total receipt quantity of all the receipts is less than corresponding requisition quantity.
10676: l_stmt_num := 20;
10677: SELECT sum(primary_quantity)
10678: INTO l_total_primary_qty
10679: from mtl_material_transactions
10680: where transaction_action_id = l_txn_action_id
10681: and transaction_source_type_id = l_txn_src_type_id
10682: and transaction_type_id = l_txn_type_id
10683: and trx_source_line_id = l_req_line_id