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.

[Home] [Help]

APPS.CSTPAPBR dependencies on MTL_INTERORG_PARAMETERS

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 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 2338: FROM mtl_interorg_parameters

2334:
2335: l_stmt_num := 84;
2336: SELECT nvl(profit_in_inv_account, -1)
2337: INTO l_profit_in_inv_account
2338: FROM mtl_interorg_parameters
2339: WHERE from_organization_id = i_ae_txn_rec.organization_id
2340: AND to_organization_id = i_ae_txn_rec.xfer_organization_id;
2341:
2342: IF (l_profit_in_inv_account = -1) THEN

Line 2525: FROM mtl_interorg_parameters mip,

2521: INTO l_io_rcv_acct,
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;

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 3087: FROM mtl_interorg_parameters mip,

3083: SELECT mip.interorg_payables_account,
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;

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 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 4306: FROM mtl_interorg_parameters

4302:
4303: l_stmt_num := 417;
4304: SELECT nvl(profit_in_inv_account, -1)
4305: INTO l_profit_in_inv_account
4306: FROM mtl_interorg_parameters
4307: WHERE from_organization_id = i_ae_txn_rec.xfer_organization_id
4308: AND to_organization_id = i_ae_txn_rec.organization_id;
4309:
4310: IF (l_profit_in_inv_account = -1) THEN

Line 4530: FROM mtl_interorg_parameters mip

4526:
4527: l_stmt_num := 434;
4528: SELECT mip.interorg_payables_account
4529: INTO l_io_pay_acct
4530: FROM mtl_interorg_parameters mip
4531: WHERE mip.from_organization_id = i_ae_txn_rec.xfer_organization_id
4532: AND mip.to_organization_id = i_ae_txn_rec.organization_id;
4533:
4534: l_stmt_num := 435;

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 5276: FROM mtl_interorg_parameters mip

5272: l_stmt_num := 592;
5273:
5274: SELECT mip.interorg_payables_account
5275: INTO l_io_pay_acct
5276: FROM mtl_interorg_parameters mip
5277: WHERE mip.from_organization_id = i_ae_txn_rec.xfer_organization_id
5278: AND mip.to_organization_id = i_ae_txn_rec.organization_id;
5279:
5280: l_stmt_num := 595;

Line 5334: FROM mtl_interorg_parameters mip,

5330: SELECT mip.interorg_payables_account,
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;

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 9618: FROM mtl_interorg_parameters mip,

9614: nvl(mip.interorg_profit_account, -1)
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;

Line 9784: FROM mtl_interorg_parameters mip,

9780: SELECT mip.interorg_payables_account,
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;

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 10070: FROM mtl_interorg_parameters mip,

10066: nvl(transfer_price,0)
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;