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_INTERORG_PARAMETERS

Line 672: FROM mtl_material_transactions mmt,mtl_interorg_parameters mip

668:
669: l_stmt_num := 12;
670: SELECT nvl(mmt.fob_point,mip.fob_point)
671: INTO l_fob_point
672: FROM mtl_material_transactions mmt,mtl_interorg_parameters mip
673: WHERE mmt.transaction_id = i_ae_txn_rec.transaction_id
674: AND mip.from_organization_id = i_ae_txn_rec.xfer_organization_id
675: AND mip.to_organization_id = i_ae_txn_rec.organization_id;
676:

Line 1967: FROM mtl_material_transactions mmt,mtl_interorg_parameters mip

1963: /* Get FOB Point */
1964: IF (i_ae_txn_rec.txn_action_id IN (12,21,15,22)) THEN -- INVCONV sikhanna
1965: SELECT nvl(mmt.fob_point,mip.fob_point)
1966: INTO l_fob_point
1967: FROM mtl_material_transactions mmt,mtl_interorg_parameters mip
1968: WHERE mmt.transaction_id = i_ae_txn_rec.transaction_id
1969: AND mip.from_organization_id = decode(i_ae_txn_rec.txn_action_id,
1970: 21,i_ae_txn_rec.organization_id,
1971: 22,i_ae_txn_rec.organization_id, -- INVCONV sikhanna

Line 2620: FROM mtl_interorg_parameters

2616:
2617: l_stmt_num := 84;
2618: SELECT nvl(profit_in_inv_account, -1)
2619: INTO l_profit_in_inv_account
2620: FROM mtl_interorg_parameters
2621: WHERE from_organization_id = i_ae_txn_rec.organization_id
2622: AND to_organization_id = i_ae_txn_rec.xfer_organization_id;
2623:
2624: IF (l_profit_in_inv_account = -1) THEN

Line 2807: FROM mtl_interorg_parameters mip,

2803: INTO l_io_rcv_acct,
2804: l_io_freight_acct,
2805: l_io_txfr_cr_acct,
2806: l_io_txfr_var_acct
2807: FROM mtl_interorg_parameters mip,
2808: mtl_material_transactions mmt
2809: WHERE mip.from_organization_id = i_ae_txn_rec.organization_id
2810: AND mip.to_organization_id = i_ae_txn_rec.xfer_organization_id
2811: AND mmt.transaction_id = i_ae_txn_rec.transaction_id;

Line 3277: FROM mtl_interorg_parameters mip,mtl_material_transactions mmt

3273: l_io_freight_acct,
3274: l_io_txfr_var_acct,
3275: l_txfr_cost, -- transfer price
3276: l_trp_cost -- transportation cost
3277: FROM mtl_interorg_parameters mip,mtl_material_transactions mmt
3278: WHERE mip.from_organization_id = i_ae_txn_rec.organization_id
3279: AND mip.to_organization_id = i_ae_txn_rec.xfer_organization_id
3280: AND mmt.transaction_id = i_ae_txn_rec.transaction_id;
3281:

Line 3369: FROM mtl_interorg_parameters mip,

3365: SELECT mip.interorg_payables_account,
3366: mmt.transportation_dist_account
3367: INTO l_io_pay_acct,
3368: l_io_freight_acct
3369: FROM mtl_interorg_parameters mip,
3370: mtl_material_transactions mmt
3371: WHERE mip.from_organization_id = i_ae_txn_rec.organization_id
3372: AND mip.to_organization_id = i_ae_txn_rec.xfer_organization_id
3373: AND mmt.transaction_id = i_ae_txn_rec.transaction_id;

Line 3622: FROM mtl_interorg_parameters mip,mtl_material_transactions mmt

3618: INTO l_io_rcv_acct,
3619: l_io_freight_acct,
3620: l_io_txfr_cr_acct,
3621: l_io_txfr_var_acct
3622: FROM mtl_interorg_parameters mip,mtl_material_transactions mmt
3623: WHERE mip.from_organization_id = i_ae_txn_rec.organization_id
3624: AND mip.to_organization_id = i_ae_txn_rec.xfer_organization_id
3625: AND mmt.transaction_id = i_ae_txn_rec.transaction_id;
3626:

Line 4006: FROM mtl_interorg_parameters mip,mtl_material_transactions mmt

4002: INTO l_io_rcv_acct,
4003: l_io_freight_acct,
4004: l_io_txfr_cr_acct,
4005: l_io_txfr_var_acct
4006: FROM mtl_interorg_parameters mip,mtl_material_transactions mmt
4007: WHERE mip.from_organization_id = i_ae_txn_rec.organization_id -- INVCONV condition is opposite
4008: AND mip.to_organization_id = i_ae_txn_rec.xfer_organization_id
4009: AND mmt.transaction_id = i_ae_txn_rec.transaction_id;
4010:

Line 4588: FROM mtl_interorg_parameters

4584:
4585: l_stmt_num := 417;
4586: SELECT nvl(profit_in_inv_account, -1)
4587: INTO l_profit_in_inv_account
4588: FROM mtl_interorg_parameters
4589: WHERE from_organization_id = i_ae_txn_rec.xfer_organization_id
4590: AND to_organization_id = i_ae_txn_rec.organization_id;
4591:
4592: IF (l_profit_in_inv_account = -1) THEN

Line 4812: FROM mtl_interorg_parameters mip

4808:
4809: l_stmt_num := 434;
4810: SELECT mip.interorg_payables_account
4811: INTO l_io_pay_acct
4812: FROM mtl_interorg_parameters mip
4813: WHERE mip.from_organization_id = i_ae_txn_rec.xfer_organization_id
4814: AND mip.to_organization_id = i_ae_txn_rec.organization_id;
4815:
4816: l_stmt_num := 435;

Line 4862: FROM mtl_interorg_parameters mip,mtl_material_transactions mmt

4858: INTO l_io_rcv_acct,
4859: l_io_freight_acct,
4860: l_io_txfr_cr_acct,
4861: l_io_txfr_var_acct
4862: FROM mtl_interorg_parameters mip,mtl_material_transactions mmt
4863: WHERE mip.from_organization_id = i_ae_txn_rec.xfer_organization_id
4864: AND mip.to_organization_id = i_ae_txn_rec.organization_id
4865: AND mmt.transaction_id = i_ae_txn_rec.transaction_id;
4866:

Line 5558: FROM mtl_interorg_parameters mip

5554: l_stmt_num := 592;
5555:
5556: SELECT mip.interorg_payables_account
5557: INTO l_io_pay_acct
5558: FROM mtl_interorg_parameters mip
5559: WHERE mip.from_organization_id = i_ae_txn_rec.xfer_organization_id
5560: AND mip.to_organization_id = i_ae_txn_rec.organization_id;
5561:
5562: l_stmt_num := 595;

Line 5616: FROM mtl_interorg_parameters mip,

5612: SELECT mip.interorg_payables_account,
5613: mmt.transportation_dist_account
5614: INTO l_io_pay_acct,
5615: l_io_freight_acct
5616: FROM mtl_interorg_parameters mip,
5617: mtl_material_transactions mmt
5618: WHERE mip.from_organization_id = i_ae_txn_rec.xfer_organization_id
5619: AND mip.to_organization_id = i_ae_txn_rec.organization_id
5620: AND mmt.transaction_id = i_ae_txn_rec.transaction_id;

Line 5793: FROM mtl_interorg_parameters mip,mtl_material_transactions mmt

5789: INTO l_io_rcv_acct,
5790: l_io_freight_acct,
5791: l_io_txfr_cr_acct,
5792: l_io_txfr_var_acct
5793: FROM mtl_interorg_parameters mip,mtl_material_transactions mmt
5794: WHERE mip.from_organization_id = i_ae_txn_rec.organization_id -- INVCONV condition is opposite
5795: AND mip.to_organization_id = i_ae_txn_rec.xfer_organization_id
5796: AND mmt.transaction_id = i_ae_txn_rec.transaction_id;
5797:

Line 10085: FROM mtl_interorg_parameters mip,

10081: nvl(mip.interorg_profit_account, -1)
10082: INTO l_io_rcv_acct,
10083: l_io_txfr_cr_acct,
10084: l_io_txfr_var_acct
10085: FROM mtl_interorg_parameters mip,
10086: mtl_material_transactions mmt
10087: WHERE mip.from_organization_id = i_ae_txn_rec.organization_id
10088: AND mip.to_organization_id = i_ae_txn_rec.xfer_organization_id
10089: AND mmt.transaction_id = i_ae_txn_rec.transaction_id;

Line 10259: FROM mtl_interorg_parameters mip,

10255: SELECT mip.interorg_payables_account,
10256: distribution_account_id
10257: INTO l_io_pay_acct,
10258: l_mmt_exp_account
10259: FROM mtl_interorg_parameters mip,
10260: mtl_material_transactions mmt
10261: WHERE mip.from_organization_id = i_ae_txn_rec.xfer_organization_id
10262: AND mip.to_organization_id = i_ae_txn_rec.organization_id
10263: AND mmt.transaction_id = i_ae_txn_rec.transaction_id;

Line 10414: FROM mtl_interorg_parameters mip,mtl_material_transactions mmt

10410: nvl(mmt.transfer_price,0)
10411: INTO l_io_rcv_acct,
10412: l_io_txfr_var_acct,
10413: l_transfer_price -- transfer price
10414: FROM mtl_interorg_parameters mip,mtl_material_transactions mmt
10415: WHERE mip.from_organization_id = i_ae_txn_rec.organization_id
10416: AND mip.to_organization_id = i_ae_txn_rec.xfer_organization_id
10417: AND mmt.transaction_id = i_ae_txn_rec.transaction_id;
10418:

Line 10545: FROM mtl_interorg_parameters mip,

10541: nvl(transfer_price,0)
10542: INTO l_io_pay_acct,
10543: l_mmt_exp_account,
10544: l_transfer_price -- transfer price
10545: FROM mtl_interorg_parameters mip,
10546: mtl_material_transactions mmt
10547: WHERE mip.from_organization_id = i_ae_txn_rec.xfer_organization_id
10548: AND mip.to_organization_id = i_ae_txn_rec.organization_id
10549: AND mmt.transaction_id = i_ae_txn_rec.transaction_id;