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

Line 1481: cst_rcv_acq_costs_adj craca

1477: l_stmt_num := 1100;
1478: Delete from mtl_pac_txn_cost_details mptcd
1479: where mptcd.transaction_id IN ( SELECT mmt.transaction_id
1480: FROM mtl_material_transactions mmt,
1481: cst_rcv_acq_costs_adj craca
1482: WHERE mmt.rcv_transaction_id
1483: = c_rec.rcv_transaction_id
1484: AND mmt.transaction_source_id
1485: = craca.header_id

Line 1504: from cst_rcv_acq_costs_adj craca

1500: AND mmt.transaction_action_id = 24
1501: AND mmt.transaction_type_id = 26
1502: AND mmt.transaction_source_type_id = 14
1503: AND mmt.transaction_source_id IN ( select craca.header_id
1504: from cst_rcv_acq_costs_adj craca
1505: where craca.period_id = i_period
1506: and craca.cost_group_id = i_cost_group_id
1507: and craca.rcv_transaction_id = c_rec.rcv_transaction_id
1508: and craca.cost_type_id = i_cost_type_id );

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

1510: l_stmt_num := 1120;
1511: Delete from rcv_accounting_events rae
1512: WHERE rae.event_type_id IN (18,19,20)
1513: AND rae.rcv_transaction_id = c_rec.rcv_transaction_id
1514: AND rae.event_source_id IN ( select header_id from cst_rcv_acq_costs_adj craca
1515: where craca.rcv_transaction_id = c_rec.rcv_transaction_id
1516: and cost_group_id = i_cost_group_id
1517: and period_id = i_period
1518: and cost_type_id = i_cost_type_id

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

1518: and cost_type_id = i_cost_type_id
1519: );
1520: l_stmt_num := 1125;
1521: Delete from cst_rcv_acq_cost_details_adj cracda
1522: where cracda.header_id = (select header_id from cst_rcv_acq_costs_adj craca
1523: where craca.rcv_transaction_id = c_rec.rcv_transaction_id
1524: and cost_group_id = i_cost_group_id
1525: and period_id = i_period
1526: and cost_type_id = i_cost_type_id);

Line 1530: Delete from cst_rcv_acq_costs_adj crac

1526: and cost_type_id = i_cost_type_id);
1527:
1528: l_stmt_num := 1130;
1529:
1530: Delete from cst_rcv_acq_costs_adj crac
1531: where crac.rcv_transaction_id = c_rec.rcv_transaction_id
1532: and cost_group_id = i_cost_group_id
1533: and period_id = i_period
1534: and cost_type_id = i_cost_type_id;

Line 1578: FROM cst_rcv_acq_costs_adj

1574: /* GET PRIOR LANDED COST*/
1575: l_stmt_num := 1170;
1576: /*SELECT nvl(max(period_id),-1)
1577: INTO l_prior_period
1578: FROM cst_rcv_acq_costs_adj
1579: WHERE rcv_transaction_id = c_rec.rcv_transaction_id
1580: AND cost_group_id = i_cost_group_id
1581: AND cost_type_id = i_cost_type_id;
1582: IF (l_prior_period <> -1) THEN

Line 1586: FROM cst_rcv_acq_costs_adj craca

1582: IF (l_prior_period <> -1) THEN
1583: l_stmt_num := 1180;
1584: SELECT craca.acquisition_cost
1585: INTO l_prior_landed_cost
1586: FROM cst_rcv_acq_costs_adj craca
1587: WHERE craca.rcv_transaction_id = c_rec.rcv_transaction_id
1588: AND craca.cost_type_id = i_cost_type_id
1589: AND craca.cost_group_id = i_cost_group_id
1590: AND craca.period_id = l_prior_period;

Line 1599: from cst_rcv_acq_costs_adj craca

1595: select craca.acquisition_cost,
1596: craca.period_id,
1597: max(craca.period_id) OVER (PARTITION BY craca.rcv_transaction_id)
1598: max_period_id
1599: from cst_rcv_acq_costs_adj craca
1600: WHERE craca.rcv_transaction_id = c_rec.rcv_transaction_id
1601: AND craca.cost_type_id = i_cost_type_id
1602: AND craca.cost_group_id = i_cost_group_id)
1603: where period_id = max_period_id;

Line 2375: from cst_rcv_acq_costs_adj craca

2371:
2372: l_stmt_num := 71;
2373: Delete from mtl_pac_txn_cost_details mptcd
2374: where mptcd.transaction_id IN ( select craca.mmt_transaction_id
2375: from cst_rcv_acq_costs_adj craca
2376: where craca.mmt_transaction_id is not null
2377: and craca.period_id = i_period
2378: and craca.cost_group_id = i_cost_group_id
2379: and craca.rcv_transaction_id = l_rec_transaction_id

Line 2384: from cst_rcv_acq_costs_adj craca

2380: and craca.cost_type_id = i_cost_type_id );
2381:
2382: Delete from mtl_material_transactions mmt
2383: where mmt.transaction_id IN ( select craca.mmt_transaction_id
2384: from cst_rcv_acq_costs_adj craca
2385: where craca.mmt_transaction_id is not null
2386: and craca.period_id = i_period
2387: and craca.cost_group_id = i_cost_group_id
2388: and craca.rcv_transaction_id = l_rec_transaction_id

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

2390:
2391: l_stmt_num := 81;
2392:
2393: Delete from cst_rcv_acq_cost_details_adj cracda
2394: where cracda.header_id = (select header_id from cst_rcv_acq_costs_adj craca
2395: where craca.rcv_transaction_id = l_rec_transaction_id
2396: and cost_group_id = i_cost_group_id
2397: and period_id = i_period
2398: and cost_type_id = i_cost_type_id);

Line 2402: Delete from cst_rcv_acq_costs_adj crac

2398: and cost_type_id = i_cost_type_id);
2399:
2400: l_stmt_num := 91;
2401:
2402: Delete from cst_rcv_acq_costs_adj crac
2403: where crac.rcv_transaction_id = l_rec_transaction_id
2404: and cost_group_id = i_cost_group_id
2405: and period_id = i_period
2406: and cost_type_id = i_cost_type_id;

Line 4058: l_acq_cost cst_rcv_acq_costs_adj.acquisition_cost%TYPE;

4054: l_qty_at_po cst_rcv_acq_cost_details_adj.quantity%TYPE;
4055: l_costed_quantity cst_rcv_acq_cost_details_adj.quantity%TYPE;
4056: l_amount_at_po cst_rcv_acq_cost_details_adj.amount%TYPE;
4057: l_total_amount cst_rcv_acq_cost_details_adj.amount%TYPE;
4058: l_acq_cost cst_rcv_acq_costs_adj.acquisition_cost%TYPE;
4059: l_cracd_count NUMBER := 0;
4060: l_stmt_num NUMBER := 0;
4061: l_acq_adjustment_amount NUMBER := 0;
4062: l_old_increments NUMBER :=0;

Line 4210: cst_rcv_acq_costs_adj crac2

4206: -----------------------------------------------------------------
4207: -- update CRACD with the calculated values
4208: ----------------------------------------------------------------
4209: UPDATE
4210: cst_rcv_acq_costs_adj crac2
4211: SET
4212: crac2.total_invoice_amount = l_total_invoice_amount,
4213: crac2.total_quantity_invoiced = l_qty_invoiced,
4214: crac2.quantity_at_po_price = l_qty_at_po,

Line 4305: FROM cst_rcv_acq_costs crac, cst_rcv_acq_costs_adj craca

4301: crac.rcv_transaction_id, nvl(crac.acquisition_cost,0),
4302: nvl(crac.net_quantity_received,0)
4303: INTO l_ori_acq_amount, l_rcv_txn_id, l_original_acq_cost,
4304: l_original_qty_received
4305: FROM cst_rcv_acq_costs crac, cst_rcv_acq_costs_adj craca
4306: WHERE craca.header_id = i_header
4307: AND crac.rcv_transaction_id = craca.rcv_transaction_id
4308: AND crac.cost_type_id = i_cost_type_id
4309: AND crac.cost_group_id = i_cost_group_id;

Line 4330: from mtl_material_transactions mmt, cst_rcv_acq_costs_adj craca

4326:
4327: /* bug fix for bug 3439082.Added joins on the cost group and cost type */
4328:
4329: select NVL(SUM(NVL(value_change,0)),0) into l_old_increments
4330: from mtl_material_transactions mmt, cst_rcv_acq_costs_adj craca
4331: where mmt.transaction_id = craca.mmt_transaction_id
4332: and craca.mmt_transaction_id is NOT NULL
4333: and craca.cost_group_id = i_cost_group_id
4334: and craca.cost_type_id = i_cost_type_id

Line 4336: from cst_rcv_acq_costs_adj craca2

4332: and craca.mmt_transaction_id is NOT NULL
4333: and craca.cost_group_id = i_cost_group_id
4334: and craca.cost_type_id = i_cost_type_id
4335: and craca.rcv_transaction_id = (select rcv_transaction_id
4336: from cst_rcv_acq_costs_adj craca2
4337: where craca2.header_id = i_header);
4338:
4339:
4340: fnd_file.put_line(fnd_file.log,'old increment :' || to_char(l_old_increments));

Line 4344: from cst_rcv_acq_costs_adj

4340: fnd_file.put_line(fnd_file.log,'old increment :' || to_char(l_old_increments));
4341:
4342: select nvl(net_quantity_received,0)
4343: into l_net_qty_received
4344: from cst_rcv_acq_costs_adj
4345: where header_id = i_header;
4346:
4347: /* Bug 2741945 */
4348:

Line 4402: from cst_rcv_acq_costs_adj craca2

4398: from rcv_transactions rt2
4399: where rt2.transaction_type in ('DELIVER')
4400: START WITH
4401: rt2.transaction_id = (select rcv_transaction_id
4402: from cst_rcv_acq_costs_adj craca2
4403: where craca2.header_id = i_header)
4404: CONNECT BY
4405: prior rt2.transaction_id = rt2.parent_transaction_id
4406: )

Line 4615: Update cst_rcv_acq_costs_adj set

4611: /* Now update the entry in CRACA with the new transaction ID of MMT */
4612:
4613: l_stmt_num := 100;
4614:
4615: Update cst_rcv_acq_costs_adj set
4616: mmt_transaction_id = l_transaction_id
4617: where header_id = i_header;
4618:
4619:

Line 4822: FROM cst_rcv_acq_costs_adj craca

4818: crac3.rcv_transaction_id = l_par_txn;
4819: l_stmt_num := 60;
4820: SELECT nvl(max(craca.period_id),-1)
4821: INTO l_lcm_adj_period
4822: FROM cst_rcv_acq_costs_adj craca
4823: WHERE craca.rcv_transaction_id = l_par_txn
4824: AND craca.cost_type_id = i_cost_type_id
4825: AND craca.cost_group_id = i_cost_group_id;
4826:

Line 4831: FROM cst_rcv_acq_costs_adj craca

4827: IF (l_lcm_adj_period <> -1) THEN
4828: l_stmt_num := 70;
4829: SELECT craca.acquisition_cost
4830: INTO l_rec_cost
4831: FROM cst_rcv_acq_costs_adj craca
4832: WHERE craca.rcv_transaction_id = l_par_txn
4833: AND craca.cost_type_id = i_cost_type_id
4834: AND craca.cost_group_id = i_cost_group_id
4835: AND craca.period_id = l_lcm_adj_period;

Line 5434: INSERT INTO cst_rcv_acq_costs_adj (

5430: elsif i_source_flag = 2 then
5431:
5432: l_stmt_no := 20;
5433:
5434: INSERT INTO cst_rcv_acq_costs_adj (
5435: HEADER_ID,
5436: COST_GROUP_ID,
5437: COST_TYPE_ID,
5438: PERIOD_ID,