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.CSTPPACQ dependencies on CST_RCV_ACQ_COSTS_ADJ

Line 1474: cst_rcv_acq_costs_adj craca

1470: l_stmt_num := 1100;
1471: Delete from mtl_pac_txn_cost_details mptcd
1472: where mptcd.transaction_id IN ( SELECT mmt.transaction_id
1473: FROM mtl_material_transactions mmt,
1474: cst_rcv_acq_costs_adj craca
1475: WHERE mmt.rcv_transaction_id
1476: = c_rec.rcv_transaction_id
1477: AND mmt.transaction_source_id
1478: = craca.header_id

Line 1497: from cst_rcv_acq_costs_adj craca

1493: AND mmt.transaction_action_id = 24
1494: AND mmt.transaction_type_id = 26
1495: AND mmt.transaction_source_type_id = 14
1496: AND mmt.transaction_source_id IN ( select craca.header_id
1497: from cst_rcv_acq_costs_adj craca
1498: where craca.period_id = i_period
1499: and craca.cost_group_id = i_cost_group_id
1500: and craca.rcv_transaction_id = c_rec.rcv_transaction_id
1501: and craca.cost_type_id = i_cost_type_id );

Line 1507: AND rae.event_source_id IN ( select header_id from cst_rcv_acq_costs_adj craca

1503: l_stmt_num := 1120;
1504: Delete from rcv_accounting_events rae
1505: WHERE rae.event_type_id IN (18,19,20)
1506: AND rae.rcv_transaction_id = c_rec.rcv_transaction_id
1507: AND rae.event_source_id IN ( select header_id from cst_rcv_acq_costs_adj craca
1508: where craca.rcv_transaction_id = c_rec.rcv_transaction_id
1509: and cost_group_id = i_cost_group_id
1510: and period_id = i_period
1511: and cost_type_id = i_cost_type_id

Line 1515: where cracda.header_id = (select header_id from cst_rcv_acq_costs_adj craca

1511: and cost_type_id = i_cost_type_id
1512: );
1513: l_stmt_num := 1125;
1514: Delete from cst_rcv_acq_cost_details_adj cracda
1515: where cracda.header_id = (select header_id from cst_rcv_acq_costs_adj craca
1516: where craca.rcv_transaction_id = c_rec.rcv_transaction_id
1517: and cost_group_id = i_cost_group_id
1518: and period_id = i_period
1519: and cost_type_id = i_cost_type_id);

Line 1523: Delete from cst_rcv_acq_costs_adj crac

1519: and cost_type_id = i_cost_type_id);
1520:
1521: l_stmt_num := 1130;
1522:
1523: Delete from cst_rcv_acq_costs_adj crac
1524: where crac.rcv_transaction_id = c_rec.rcv_transaction_id
1525: and cost_group_id = i_cost_group_id
1526: and period_id = i_period
1527: and cost_type_id = i_cost_type_id;

Line 1571: FROM cst_rcv_acq_costs_adj

1567: /* GET PRIOR LANDED COST*/
1568: l_stmt_num := 1170;
1569: /*SELECT nvl(max(period_id),-1)
1570: INTO l_prior_period
1571: FROM cst_rcv_acq_costs_adj
1572: WHERE rcv_transaction_id = c_rec.rcv_transaction_id
1573: AND cost_group_id = i_cost_group_id
1574: AND cost_type_id = i_cost_type_id;
1575: IF (l_prior_period <> -1) THEN

Line 1579: FROM cst_rcv_acq_costs_adj craca

1575: IF (l_prior_period <> -1) THEN
1576: l_stmt_num := 1180;
1577: SELECT craca.acquisition_cost
1578: INTO l_prior_landed_cost
1579: FROM cst_rcv_acq_costs_adj craca
1580: WHERE craca.rcv_transaction_id = c_rec.rcv_transaction_id
1581: AND craca.cost_type_id = i_cost_type_id
1582: AND craca.cost_group_id = i_cost_group_id
1583: AND craca.period_id = l_prior_period;

Line 1592: from cst_rcv_acq_costs_adj craca

1588: select craca.acquisition_cost,
1589: craca.period_id,
1590: max(craca.period_id) OVER (PARTITION BY craca.rcv_transaction_id)
1591: max_period_id
1592: from cst_rcv_acq_costs_adj craca
1593: WHERE craca.rcv_transaction_id = c_rec.rcv_transaction_id
1594: AND craca.cost_type_id = i_cost_type_id
1595: AND craca.cost_group_id = i_cost_group_id)
1596: where period_id = max_period_id;

Line 2327: from cst_rcv_acq_costs_adj craca

2323:
2324: l_stmt_num := 71;
2325: Delete from mtl_pac_txn_cost_details mptcd
2326: where mptcd.transaction_id IN ( select craca.mmt_transaction_id
2327: from cst_rcv_acq_costs_adj craca
2328: where craca.mmt_transaction_id is not null
2329: and craca.period_id = i_period
2330: and craca.cost_group_id = i_cost_group_id
2331: and craca.rcv_transaction_id = c_rec.transaction_id

Line 2336: from cst_rcv_acq_costs_adj craca

2332: and craca.cost_type_id = i_cost_type_id );
2333:
2334: Delete from mtl_material_transactions mmt
2335: where mmt.transaction_id IN ( select craca.mmt_transaction_id
2336: from cst_rcv_acq_costs_adj craca
2337: where craca.mmt_transaction_id is not null
2338: and craca.period_id = i_period
2339: and craca.cost_group_id = i_cost_group_id
2340: and craca.rcv_transaction_id = c_rec.transaction_id

Line 2346: where cracda.header_id = (select header_id from cst_rcv_acq_costs_adj craca

2342:
2343: l_stmt_num := 81;
2344:
2345: Delete from cst_rcv_acq_cost_details_adj cracda
2346: where cracda.header_id = (select header_id from cst_rcv_acq_costs_adj craca
2347: where craca.rcv_transaction_id = c_rec.transaction_id
2348: and cost_group_id = i_cost_group_id
2349: and period_id = i_period
2350: and cost_type_id = i_cost_type_id);

Line 2354: Delete from cst_rcv_acq_costs_adj crac

2350: and cost_type_id = i_cost_type_id);
2351:
2352: l_stmt_num := 91;
2353:
2354: Delete from cst_rcv_acq_costs_adj crac
2355: where crac.rcv_transaction_id = c_rec.transaction_id
2356: and cost_group_id = i_cost_group_id
2357: and period_id = i_period
2358: and cost_type_id = i_cost_type_id;

Line 3975: l_acq_cost cst_rcv_acq_costs_adj.acquisition_cost%TYPE;

3971: l_qty_at_po cst_rcv_acq_cost_details_adj.quantity%TYPE;
3972: l_costed_quantity cst_rcv_acq_cost_details_adj.quantity%TYPE;
3973: l_amount_at_po cst_rcv_acq_cost_details_adj.amount%TYPE;
3974: l_total_amount cst_rcv_acq_cost_details_adj.amount%TYPE;
3975: l_acq_cost cst_rcv_acq_costs_adj.acquisition_cost%TYPE;
3976: l_cracd_count NUMBER := 0;
3977: l_stmt_num NUMBER := 0;
3978: l_acq_adjustment_amount NUMBER := 0;
3979: l_old_increments NUMBER :=0;

Line 4119: cst_rcv_acq_costs_adj crac2

4115: -----------------------------------------------------------------
4116: -- update CRACD with the calculated values
4117: ----------------------------------------------------------------
4118: UPDATE
4119: cst_rcv_acq_costs_adj crac2
4120: SET
4121: crac2.total_invoice_amount = l_total_invoice_amount,
4122: crac2.total_quantity_invoiced = l_qty_invoiced,
4123: crac2.quantity_at_po_price = l_qty_at_po,

Line 4214: FROM cst_rcv_acq_costs crac, cst_rcv_acq_costs_adj craca

4210: crac.rcv_transaction_id, nvl(crac.acquisition_cost,0),
4211: nvl(crac.net_quantity_received,0)
4212: INTO l_ori_acq_amount, l_rcv_txn_id, l_original_acq_cost,
4213: l_original_qty_received
4214: FROM cst_rcv_acq_costs crac, cst_rcv_acq_costs_adj craca
4215: WHERE craca.header_id = i_header
4216: AND crac.rcv_transaction_id = craca.rcv_transaction_id
4217: AND crac.cost_type_id = i_cost_type_id
4218: AND crac.cost_group_id = i_cost_group_id;

Line 4239: from mtl_material_transactions mmt, cst_rcv_acq_costs_adj craca

4235:
4236: /* bug fix for bug 3439082.Added joins on the cost group and cost type */
4237:
4238: select NVL(SUM(NVL(value_change,0)),0) into l_old_increments
4239: from mtl_material_transactions mmt, cst_rcv_acq_costs_adj craca
4240: where mmt.transaction_id = craca.mmt_transaction_id
4241: and craca.mmt_transaction_id is NOT NULL
4242: and craca.cost_group_id = i_cost_group_id
4243: and craca.cost_type_id = i_cost_type_id

Line 4245: from cst_rcv_acq_costs_adj craca2

4241: and craca.mmt_transaction_id is NOT NULL
4242: and craca.cost_group_id = i_cost_group_id
4243: and craca.cost_type_id = i_cost_type_id
4244: and craca.rcv_transaction_id = (select rcv_transaction_id
4245: from cst_rcv_acq_costs_adj craca2
4246: where craca2.header_id = i_header);
4247:
4248:
4249: fnd_file.put_line(fnd_file.log,'old increment :' || to_char(l_old_increments));

Line 4253: from cst_rcv_acq_costs_adj

4249: fnd_file.put_line(fnd_file.log,'old increment :' || to_char(l_old_increments));
4250:
4251: select nvl(net_quantity_received,0)
4252: into l_net_qty_received
4253: from cst_rcv_acq_costs_adj
4254: where header_id = i_header;
4255:
4256: /* Bug 2741945 */
4257:

Line 4311: from cst_rcv_acq_costs_adj craca2

4307: from rcv_transactions rt2
4308: where rt2.transaction_type in ('DELIVER')
4309: START WITH
4310: rt2.transaction_id = (select rcv_transaction_id
4311: from cst_rcv_acq_costs_adj craca2
4312: where craca2.header_id = i_header)
4313: CONNECT BY
4314: prior rt2.transaction_id = rt2.parent_transaction_id
4315: )

Line 4474: Update cst_rcv_acq_costs_adj set

4470: /* Now update the entry in CRACA with the new transaction ID of MMT */
4471:
4472: l_stmt_num := 100;
4473:
4474: Update cst_rcv_acq_costs_adj set
4475: mmt_transaction_id = l_transaction_id
4476: where header_id = i_header;
4477:
4478:

Line 4677: FROM cst_rcv_acq_costs_adj craca

4673: crac3.rcv_transaction_id = l_par_txn;
4674: l_stmt_num := 60;
4675: SELECT nvl(max(craca.period_id),-1)
4676: INTO l_lcm_adj_period
4677: FROM cst_rcv_acq_costs_adj craca
4678: WHERE craca.rcv_transaction_id = l_par_txn
4679: AND craca.cost_type_id = i_cost_type_id
4680: AND craca.cost_group_id = i_cost_group_id;
4681:

Line 4686: FROM cst_rcv_acq_costs_adj craca

4682: IF (l_lcm_adj_period <> -1) THEN
4683: l_stmt_num := 70;
4684: SELECT craca.acquisition_cost
4685: INTO l_rec_cost
4686: FROM cst_rcv_acq_costs_adj craca
4687: WHERE craca.rcv_transaction_id = l_par_txn
4688: AND craca.cost_type_id = i_cost_type_id
4689: AND craca.cost_group_id = i_cost_group_id
4690: AND craca.period_id = l_lcm_adj_period;

Line 5122: INSERT INTO cst_rcv_acq_costs_adj (

5118: elsif i_source_flag = 2 then
5119:
5120: l_stmt_no := 20;
5121:
5122: INSERT INTO cst_rcv_acq_costs_adj (
5123: HEADER_ID,
5124: COST_GROUP_ID,
5125: COST_TYPE_ID,
5126: PERIOD_ID,