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.CSTPACDP dependencies on MTL_TRANSACTION_ACCOUNTS

Line 2258: FROM mtl_transaction_accounts

2254:
2255: l_stmt_num := 70;
2256: SELECT SUM(NVL(base_transaction_value,0))
2257: INTO l_value
2258: FROM mtl_transaction_accounts
2259: WHERE transaction_id = i_txn_id
2260: AND organization_id = i_org_id
2261: ;
2262:

Line 2998: FROM mtl_transaction_accounts

2994: else
2995: /* Book InterOrg profit */
2996: SELECT SUM(NVL(base_transaction_value,0))
2997: INTO l_value
2998: FROM mtl_transaction_accounts
2999: WHERE transaction_id = i_txn_id
3000: AND organization_id = l_from_org
3001: ;
3002:

Line 3272: from mtl_transaction_accounts

3268: if (l_pd_txfr_ind = 0)
3269: then
3270: select nvl(sum(base_transaction_value),0)
3271: into l_value
3272: from mtl_transaction_accounts
3273: where transaction_id = i_txn_id
3274: and organization_id = l_from_org;
3275: else
3276: l_value := i_txf_price * l_snd_qty; -- OPM INVCONV umoogala/sschinch

Line 3335: FROM mtl_transaction_accounts

3331:
3332: /* Book interorg profit */
3333: SELECT SUM(NVL(base_transaction_value,0))
3334: INTO l_value
3335: FROM mtl_transaction_accounts
3336: WHERE transaction_id = i_txn_id
3337: AND organization_id = l_from_org
3338: ;
3339:

Line 4027: from mtl_transaction_accounts

4023: then
4024:
4025: select nvl(sum(base_transaction_value), 0)
4026: into l_value
4027: from mtl_transaction_accounts
4028: where transaction_id = i_txn_id
4029: and organization_id = l_to_org
4030: and accounting_line_type = 3
4031: and cost_element_id = 2;

Line 4066: from mtl_transaction_accounts

4062: if (l_pd_txfr_ind = 0)
4063: then
4064: select sum(base_transaction_value)
4065: into l_value
4066: from mtl_transaction_accounts
4067: where transaction_id = decode(i_txn_act_id, 3, i_txf_txn_id,i_txn_id)
4068: and organization_id = l_from_org
4069: and accounting_line_type = 10;
4070:

Line 6781: insert into mtl_transaction_accounts (

6777: end if;
6778:
6779: l_stmt_num := 10;
6780:
6781: insert into mtl_transaction_accounts (
6782: inv_sub_ledger_id, /* R12 - SLA Distribution Link */
6783: transaction_id,
6784: reference_account,
6785: last_update_date,

Line 6939: from mtl_transaction_accounts

6935: END IF;
6936:
6937: select nvl(sum(base_transaction_value),0), nvl(sum(transaction_value),0)
6938: into l_base_value, l_value
6939: from mtl_transaction_accounts
6940: where transaction_id = i_txn_id
6941: and organization_id = i_org_id
6942: and accounting_line_type <> 15;
6943:

Line 6966: FROM mtl_transaction_accounts

6962: and l_value
6963: */
6964: SELECT MAX(rowid)
6965: INTO l_rowid
6966: FROM mtl_transaction_accounts
6967: WHERE transaction_id = i_txn_id
6968: AND organization_id = i_org_id
6969: AND accounting_line_type NOT IN (9,10,15) /* this condition added for 4052277 */
6970: AND sign(base_transaction_value - l_base_value) *

Line 6981: update mtl_transaction_accounts

6977: IF (l_debug = 'Y') THEN
6978: fnd_file.put_line(fnd_file.log,'Adjusting Balance value against record ' || l_rowid);
6979: END IF;
6980:
6981: update mtl_transaction_accounts
6982: set transaction_value = decode(transaction_value, NULL,
6983: decode(l_value, 0, NULL,-1*l_value),
6984: transaction_value - l_value),
6985: base_transaction_value = base_transaction_value - l_base_value

Line 6998: FROM mtl_transaction_accounts

6994: END IF;
6995:
6996: SELECT MAX(rowid)
6997: INTO l_rowid
6998: FROM mtl_transaction_accounts
6999: WHERE transaction_id = i_txn_id
7000: AND organization_id = i_org_id
7001: AND accounting_line_type NOT IN (9,10,15)
7002: AND sign(base_transaction_value) *

Line 7011: update mtl_transaction_accounts

7007: IF (l_debug = 'Y') THEN
7008: fnd_file.put_line(fnd_file.log,'Adjusting the transaction value balance value against record ' || l_rowid);
7009: END IF;
7010:
7011: update mtl_transaction_accounts
7012: set transaction_value = decode(transaction_value, NULL,
7013: decode(l_value, 0, NULL,-1*l_value),
7014: transaction_value - l_value)
7015: where rowid = l_rowid;

Line 7024: FROM mtl_transaction_accounts

7020: END IF;
7021:
7022: SELECT MAX(rowid)
7023: INTO l_rowid
7024: FROM mtl_transaction_accounts
7025: WHERE transaction_id = i_txn_id
7026: AND organization_id = i_org_id
7027: AND accounting_line_type NOT IN (9,10,15)
7028: AND sign(base_transaction_value-l_base_value) *

Line 7036: update mtl_transaction_accounts

7032: IF (l_debug = 'Y') THEN
7033: fnd_file.put_line(fnd_file.log,'Adjusting the base transaction value balance value against record ' || l_rowid);
7034: END IF;
7035:
7036: update mtl_transaction_accounts
7037: set base_transaction_value = base_transaction_value - l_base_value
7038: where rowid = l_rowid;
7039:
7040: END IF;

Line 8117: FROM mtl_transaction_accounts

8113: */
8114:
8115: SELECT SUM(NVL(base_transaction_value,0))
8116: INTO interorg_profit
8117: FROM mtl_transaction_accounts
8118: WHERE transaction_id = trans_id
8119: AND organization_id = org_id
8120: ;
8121:

Line 8531: FROM mtl_transaction_accounts mta

8527:
8528:
8529: UPDATE mtl_material_transactions
8530: SET variance_amount = (SELECT -1 * nvl(sum(base_transaction_value),0)
8531: FROM mtl_transaction_accounts mta
8532: WHERE mta.transaction_id = trans_id
8533: AND mta.organization_id = org_id
8534: AND encumbrance_type_id is null)
8535: WHERE transaction_id = trans_id

Line 8813: FROM mtl_transaction_accounts mta

8809: THEN
8810:
8811: UPDATE mtl_material_transactions
8812: SET variance_amount = (SELECT -1 * nvl(sum(base_transaction_value),0)
8813: FROM mtl_transaction_accounts mta
8814: WHERE mta.transaction_id = trans_id
8815: AND mta.organization_id = org_id
8816: AND encumbrance_type_id is null)
8817: WHERE transaction_id = trans_id

Line 9068: FROM mtl_transaction_accounts

9064:
9065: -- interorg_profit := interorg_xfr_price - (item_cost + (trp_cost/p_qty));
9066: SELECT SUM(NVL(base_transaction_value,0))
9067: INTO interorg_profit
9068: FROM mtl_transaction_accounts
9069: WHERE transaction_id = trans_id
9070: AND organization_id = org_id
9071: ;
9072:

Line 9359: FROM mtl_transaction_accounts mta

9355: -- ppv_amt := (item_cost * p_qty) - ((interorg_xfr_price * p_qty) + trp_cost);
9356:
9357: UPDATE mtl_material_transactions
9358: SET variance_amount = (SELECT -1 * nvl(sum(base_transaction_value),0)
9359: FROM mtl_transaction_accounts mta
9360: WHERE mta.transaction_id = trans_id
9361: AND mta.organization_id = org_id
9362: AND encumbrance_type_id is null)
9363: WHERE transaction_id = trans_id

Line 9718: l_mta_rec mtl_transaction_accounts%ROWTYPE;

9714: l_stmt_num NUMBER;
9715: l_rowid ROWID;
9716: l_base_value NUMBER;
9717: l_value NUMBER;
9718: l_mta_rec mtl_transaction_accounts%ROWTYPE;
9719: l_debug VARCHAR2(1);
9720: l_sign NUMBER;
9721: BEGIN
9722:

Line 9860: FROM mtl_transaction_accounts a,

9856: ,l_mta_rec.PROGRAM_UPDATE_DATE
9857: ,l_mta_rec.ENCUMBRANCE_TYPE_ID
9858: ,l_mta_rec.REPETITIVE_SCHEDULE_ID
9859: ,l_mta_rec.USSGL_TRANSACTION_CODE
9860: FROM mtl_transaction_accounts a,
9861: mtl_parameters b
9862: WHERE a.transaction_id = i_txn_id
9863: AND a.organization_id = i_org_id
9864: AND b.organization_id = a.organization_id;

Line 9899: INSERT INTO mtl_transaction_accounts

9895: select decode(sign(l_mta_rec.base_transaction_value),-1,-1,1) into l_sign from dual;
9896: l_mta_rec.PRIMARY_QUANTITY := l_sign * abs(l_mta_rec.PRIMARY_QUANTITY);
9897:
9898:
9899: INSERT INTO mtl_transaction_accounts
9900: ( TRANSACTION_ID
9901: ,REFERENCE_ACCOUNT
9902: ,LAST_UPDATE_DATE
9903: ,LAST_UPDATED_BY

Line 10006: INSERT INTO mtl_transaction_accounts

10002: select decode(sign(l_mta_rec.base_transaction_value),-1,-1,1) into l_sign from dual;
10003: l_mta_rec.PRIMARY_QUANTITY := l_sign * abs(l_mta_rec.PRIMARY_QUANTITY);
10004:
10005:
10006: INSERT INTO mtl_transaction_accounts
10007: ( TRANSACTION_ID
10008: ,REFERENCE_ACCOUNT
10009: ,LAST_UPDATE_DATE
10010: ,LAST_UPDATED_BY

Line 10098: FROM mtl_transaction_accounts

10094: FROM DUAL;
10095: /*Find a row which can absorb l_value */
10096: SELECT MAX(rowid)
10097: INTO l_rowid
10098: FROM mtl_transaction_accounts
10099: WHERE transaction_id = i_txn_id
10100: AND organization_id = i_org_id
10101: AND accounting_line_type NOT IN (9,10,15)
10102: AND sign(base_transaction_value) *

Line 10111: update mtl_transaction_accounts

10107: IF (G_DEBUG = 'Y') THEN
10108: fnd_file.put_line(fnd_file.log,'Adjusting the transaction value balance value against record ' || l_rowid);
10109: END IF;
10110:
10111: update mtl_transaction_accounts
10112: set transaction_value = decode(transaction_value, NULL,
10113: decode(l_value, 0, NULL,-1*l_value),
10114: transaction_value - l_value)
10115: where rowid = l_rowid;