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

Line 554: l_header cst_rcv_acq_costs.header_id%TYPE;

550: DECLARE
551: l_rec_ct NUMBER := 0;
552: l_nqr rcv_transactions.quantity%TYPE := 0;
553: l_inv_count number;
554: l_header cst_rcv_acq_costs.header_id%TYPE;
555: l_primary_uom mtl_system_items.primary_uom_code%TYPE;
556: l_po_uom mtl_units_of_measure.uom_code%TYPE;
557: l_po_uom_code po_lines_all.unit_meas_lookup_code%TYPE;
558: l_po_price po_lines_all.unit_price%TYPE;

Line 580: FROM cst_rcv_acq_costs crac

576: l_stmt_num := 60;
577:
578: SELECT count(rcv_transaction_id)
579: INTO l_rec_ct
580: FROM cst_rcv_acq_costs crac
581: WHERE crac.rcv_transaction_id = c_rec.transaction_id
582: AND crac.period_id = i_period
583: AND crac.cost_type_id = i_cost_type_id
584: AND crac.cost_group_id = i_cost_group_id

Line 605: SELECT cst_rcv_acq_costs_s.nextval

601:
602: -----------------------------------------------------------
603: -- Get next header id from sequence
604: -----------------------------------------------------------
605: SELECT cst_rcv_acq_costs_s.nextval
606: INTO l_header
607: FROM dual;
608:
609: /* begin changes for dropshipment project */

Line 849: -- 2.2 Insert inTO cst_rcV_ACQ_COSTS a row for the receipt

845: l_po_price := l_po_price * l_poll_quantity / l_pri_poll_quantity;
846: End if;
847:
848: --------------------------------------------------------
849: -- 2.2 Insert inTO cst_rcV_ACQ_COSTS a row for the receipt
850: -- for cost type, period, cost group
851: -- setting quantity_invoiced, quantity_at_po_price,
852: -- total_invoice_amount, amount_at_po_price, total_amount,
853: -- costed_quantity, acqcuisition_cost to NULL for now

Line 1209: l_header_id cst_rcv_acq_costs.header_id%TYPE;

1205: l_rec_ct NUMBER;
1206: l_rct_adj_landed_cost NUMBER;
1207: l_lcm_acq_cost NUMBER;
1208: l_net_qty_rec rcv_transactions.quantity%TYPE := 0;
1209: l_header_id cst_rcv_acq_costs.header_id%TYPE;
1210: l_nr_tax_rate NUMBER;
1211: l_primary_uom mtl_system_items.primary_uom_code%TYPE;
1212: l_po_uom mtl_units_of_measure.uom_code%TYPE;
1213: l_po_uom_code po_lines_all.unit_meas_lookup_code%TYPE;

Line 1223: FROM cst_rcv_acq_costs crac

1219: BEGIN
1220: l_stmt_num := 1000;
1221: SELECT count(rcv_transaction_id)
1222: INTO l_rec_ct
1223: FROM cst_rcv_acq_costs crac
1224: WHERE crac.rcv_transaction_id = c_rec.transaction_id
1225: AND crac.period_id = i_period
1226: AND crac.cost_type_id = i_cost_type_id
1227: AND crac.cost_group_id = i_cost_group_id

Line 1275: SELECT cst_rcv_acq_costs_s.nextval

1271: RAISE CST_FAIL_GET_NQR;
1272: END IF;
1273:
1274: l_stmt_num := 1040;
1275: SELECT cst_rcv_acq_costs_s.nextval
1276: INTO l_header_id
1277: FROM dual;
1278:
1279: l_stmt_num := 1050;

Line 1442: l_header_id cst_rcv_acq_costs.header_id%TYPE;

1438: l_exp_acct_id NUMBER;
1439: l_new_landed_cost NUMBER;
1440: l_prior_landed_cost NUMBER;
1441: l_prior_period NUMBER;
1442: l_header_id cst_rcv_acq_costs.header_id%TYPE;
1443: l_exp_account_id NUMBER;
1444: l_transaction_id NUMBER;
1445: l_rcv_accounting_event_id NUMBER;
1446: l_dr_flag BOOLEAN;

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 1608: FROM cst_rcv_acq_costs crac3

1604: IF (l_prior_landed_cost = -1) THEN
1605: l_stmt_num := 1190;
1606: SELECT nvl(max(crac3.acquisition_cost),-1)
1607: INTO l_prior_landed_cost
1608: FROM cst_rcv_acq_costs crac3
1609: WHERE crac3.cost_type_id = i_cost_type_id
1610: AND crac3.cost_group_id = i_cost_group_id
1611: AND crac3.rcv_transaction_id = c_rec.rcv_transaction_id;
1612:

Line 1652: SELECT cst_rcv_acq_costs_s.nextval

1648: END IF;
1649: END IF;
1650: IF (l_prior_landed_cost <> l_new_landed_cost) THEN
1651: l_stmt_num := 1210;
1652: SELECT cst_rcv_acq_costs_s.nextval
1653: INTO l_header_id
1654: FROM dual;
1655:
1656: l_stmt_num := 1220;

Line 2347: l_header cst_rcv_acq_costs.header_id%TYPE;

2343: DECLARE
2344: l_rec_ct NUMBER := 0;
2345: l_nqr rcv_transactions.quantity%TYPE := 0;
2346: l_inv_count number;
2347: l_header cst_rcv_acq_costs.header_id%TYPE;
2348: l_primary_uom mtl_system_items.primary_uom_code%TYPE;
2349: l_po_uom mtl_units_of_measure.uom_code%TYPE;
2350: l_po_uom_code po_lines_all.unit_meas_lookup_code%TYPE;
2351: l_po_price po_lines_all.unit_price%TYPE;

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 2446: SELECT cst_rcv_acq_costs_s.nextval

2442:
2443: -----------------------------------------------------------
2444: -- Get next header id from sequence
2445: -----------------------------------------------------------
2446: SELECT cst_rcv_acq_costs_s.nextval
2447: INTO l_header
2448: FROM dual;
2449:
2450: /* begin changes for dropshipment project */

Line 2687: -- 2.2 Insert inTO cst_rcV_ACQ_COSTS a row for the receipt

2683: l_po_price := l_po_price * l_poll_quantity / l_pri_poll_quantity;
2684: End if;
2685:
2686: --------------------------------------------------------
2687: -- 2.2 Insert inTO cst_rcV_ACQ_COSTS a row for the receipt
2688: -- for cost type, period, cost group
2689: -- setting quantity_invoiced, quantity_at_po_price,
2690: -- total_invoice_amount, amount_at_po_price, total_amount,
2691: -- costed_quantity, acqcuisition_cost to NULL for now

Line 3819: l_acq_cost cst_rcv_acq_costs.acquisition_cost%TYPE;

3815: l_qty_at_po cst_rcv_acq_cost_details.quantity%TYPE;
3816: l_costed_quantity cst_rcv_acq_cost_details.quantity%TYPE;
3817: l_amount_at_po cst_rcv_acq_cost_details.amount%TYPE;
3818: l_total_amount cst_rcv_acq_cost_details.amount%TYPE;
3819: l_acq_cost cst_rcv_acq_costs.acquisition_cost%TYPE;
3820: l_cracd_count NUMBER := 0;
3821: l_stmt_num NUMBER := 0;
3822: CST_NULL_ACQ_COST EXCEPTION;
3823: BEGIN

Line 3938: cst_rcv_acq_costs crac2

3934:
3935: l_stmt_num := 28;
3936:
3937: UPDATE
3938: cst_rcv_acq_costs crac2
3939: SET
3940: crac2.total_invoice_amount = l_total_invoice_amount,
3941: crac2.total_quantity_invoiced = l_qty_invoiced,
3942: crac2.quantity_at_po_price = l_qty_at_po,

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 4794: cst_rcv_acq_costs crac3

4790: nvl(crac3.acquisition_cost,-1)
4791: INTO
4792: l_rec_cost
4793: FROM
4794: cst_rcv_acq_costs crac3
4795: WHERE
4796: crac3.cost_type_id = i_cost_type_id AND
4797: crac3.cost_group_id = i_cost_group_id AND
4798: crac3.rcv_transaction_id = l_par_txn;

Line 4814: cst_rcv_acq_costs crac3

4810: nvl(max(crac3.acquisition_cost),-1)
4811: INTO
4812: l_rec_cost
4813: FROM
4814: cst_rcv_acq_costs crac3
4815: WHERE
4816: crac3.cost_type_id = i_cost_type_id AND
4817: crac3.cost_group_id = i_cost_group_id AND
4818: crac3.rcv_transaction_id = l_par_txn;

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 5375: INSERT INTO cst_rcv_acq_costs (

5371: BEGIN
5372:
5373: If i_source_flag = 1 then
5374:
5375: INSERT INTO cst_rcv_acq_costs (
5376: HEADER_ID,
5377: COST_GROUP_ID,
5378: COST_TYPE_ID,
5379: PERIOD_ID,

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,