APPS.CSTPACDP dependencies on MTL_TRANSACTION_ACCOUNTS

Line 2167: FROM mtl_transaction_accounts

2163:
2164: l_stmt_num := 70;
2165: SELECT SUM(NVL(base_transaction_value,0))
2166: INTO l_value
2167: FROM mtl_transaction_accounts
2168: WHERE transaction_id = i_txn_id
2169: AND organization_id = i_org_id
2170: ;
2171:

Line 2907: FROM mtl_transaction_accounts

2903: else
2904: /* Book InterOrg profit */
2905: SELECT SUM(NVL(base_transaction_value,0))
2906: INTO l_value
2907: FROM mtl_transaction_accounts
2908: WHERE transaction_id = i_txn_id
2909: AND organization_id = l_from_org
2910: ;
2911:

Line 3181: from mtl_transaction_accounts

3177: if (l_pd_txfr_ind = 0)
3178: then
3179: select nvl(sum(base_transaction_value),0)
3180: into l_value
3181: from mtl_transaction_accounts
3182: where transaction_id = i_txn_id
3183: and organization_id = l_from_org;
3184: else
3185: l_value := i_txf_price * l_snd_qty; -- OPM INVCONV umoogala/sschinch

Line 3244: FROM mtl_transaction_accounts

3240:
3241: /* Book interorg profit */
3242: SELECT SUM(NVL(base_transaction_value,0))
3243: INTO l_value
3244: FROM mtl_transaction_accounts
3245: WHERE transaction_id = i_txn_id
3246: AND organization_id = l_from_org
3247: ;
3248:

Line 3936: from mtl_transaction_accounts

3932: then
3933:
3934: select nvl(sum(base_transaction_value), 0)
3935: into l_value
3936: from mtl_transaction_accounts
3937: where transaction_id = i_txn_id
3938: and organization_id = l_to_org
3939: and accounting_line_type = 3
3940: and cost_element_id = 2;

Line 3975: from mtl_transaction_accounts

3971: if (l_pd_txfr_ind = 0)
3972: then
3973: select sum(base_transaction_value)
3974: into l_value
3975: from mtl_transaction_accounts
3976: where transaction_id = decode(i_txn_act_id, 3, i_txf_txn_id,i_txn_id)
3977: and organization_id = l_from_org
3978: and accounting_line_type = 10;
3979:

Line 6658: insert into mtl_transaction_accounts (

6654: end if;
6655:
6656: l_stmt_num := 10;
6657:
6658: insert into mtl_transaction_accounts (
6659: inv_sub_ledger_id, /* R12 - SLA Distribution Link */
6660: transaction_id,
6661: reference_account,
6662: last_update_date,

Line 6805: from mtl_transaction_accounts

6801: fnd_file.put_line(fnd_file.log,'In balance account!!!!');
6802:
6803: select nvl(sum(base_transaction_value),0), nvl(sum(transaction_value),0)
6804: into l_base_value, l_value
6805: from mtl_transaction_accounts
6806: where transaction_id = i_txn_id
6807: and organization_id = i_org_id;
6808:
6809: if (l_base_value = 0 and l_value = 0) then

Line 6827: FROM mtl_transaction_accounts

6823: /* Exclude the encumbrance line as well */
6824:
6825: SELECT MAX(rowid)
6826: INTO l_rowid
6827: FROM mtl_transaction_accounts
6828: WHERE transaction_id = i_txn_id
6829: AND organization_id = i_org_id
6830: AND accounting_line_type NOT IN (9,10,15); /* this condition added for 4052277 */
6831:

Line 6836: update mtl_transaction_accounts

6832: l_stmt_num := 30;
6833: fnd_file.put_line(fnd_file.log,'Adjusting Balance value against record ' || l_rowid);
6834:
6835:
6836: update mtl_transaction_accounts
6837: set transaction_value = decode(transaction_value, NULL,
6838: decode(l_value, 0, NULL,-1*l_value),
6839: transaction_value - l_value),
6840: base_transaction_value = base_transaction_value - l_base_value

Line 7918: FROM mtl_transaction_accounts

7914: */
7915:
7916: SELECT SUM(NVL(base_transaction_value,0))
7917: INTO interorg_profit
7918: FROM mtl_transaction_accounts
7919: WHERE transaction_id = trans_id
7920: AND organization_id = org_id
7921: ;
7922:

Line 8332: FROM mtl_transaction_accounts mta

8328:
8329:
8330: UPDATE mtl_material_transactions
8331: SET variance_amount = (SELECT -1 * nvl(sum(base_transaction_value),0)
8332: FROM mtl_transaction_accounts mta
8333: WHERE mta.transaction_id = trans_id
8334: AND mta.organization_id = org_id
8335: AND encumbrance_type_id is null)
8336: WHERE transaction_id = trans_id

Line 8614: FROM mtl_transaction_accounts mta

8610: THEN
8611:
8612: UPDATE mtl_material_transactions
8613: SET variance_amount = (SELECT -1 * nvl(sum(base_transaction_value),0)
8614: FROM mtl_transaction_accounts mta
8615: WHERE mta.transaction_id = trans_id
8616: AND mta.organization_id = org_id
8617: AND encumbrance_type_id is null)
8618: WHERE transaction_id = trans_id

Line 8869: FROM mtl_transaction_accounts

8865:
8866: -- interorg_profit := interorg_xfr_price - (item_cost + (trp_cost/p_qty));
8867: SELECT SUM(NVL(base_transaction_value,0))
8868: INTO interorg_profit
8869: FROM mtl_transaction_accounts
8870: WHERE transaction_id = trans_id
8871: AND organization_id = org_id
8872: ;
8873:

Line 9160: FROM mtl_transaction_accounts mta

9156: -- ppv_amt := (item_cost * p_qty) - ((interorg_xfr_price * p_qty) + trp_cost);
9157:
9158: UPDATE mtl_material_transactions
9159: SET variance_amount = (SELECT -1 * nvl(sum(base_transaction_value),0)
9160: FROM mtl_transaction_accounts mta
9161: WHERE mta.transaction_id = trans_id
9162: AND mta.organization_id = org_id
9163: AND encumbrance_type_id is null)
9164: WHERE transaction_id = trans_id

Line 9519: l_mta_rec mtl_transaction_accounts%ROWTYPE;

9515: l_stmt_num NUMBER;
9516: l_rowid ROWID;
9517: l_base_value NUMBER;
9518: l_value NUMBER;
9519: l_mta_rec mtl_transaction_accounts%ROWTYPE;
9520: l_debug VARCHAR2(1);
9521: BEGIN
9522:
9523: IF G_DEBUG = 'Y' THEN

Line 9657: FROM mtl_transaction_accounts a,

9653: ,l_mta_rec.PROGRAM_UPDATE_DATE
9654: ,l_mta_rec.ENCUMBRANCE_TYPE_ID
9655: ,l_mta_rec.REPETITIVE_SCHEDULE_ID
9656: ,l_mta_rec.USSGL_TRANSACTION_CODE
9657: FROM mtl_transaction_accounts a,
9658: mtl_parameters b
9659: WHERE a.transaction_id = i_txn_id
9660: AND a.organization_id = i_org_id
9661: AND b.organization_id = a.organization_id;

Line 9694: INSERT INTO mtl_transaction_accounts

9690:
9691: l_mta_rec.PRIMARY_QUANTITY := -1 * l_mta_rec.PRIMARY_QUANTITY;
9692:
9693:
9694: INSERT INTO mtl_transaction_accounts
9695: ( TRANSACTION_ID
9696: ,REFERENCE_ACCOUNT
9697: ,LAST_UPDATE_DATE
9698: ,LAST_UPDATED_BY