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 846: -- 2.2 Insert inTO cst_rcV_ACQ_COSTS a row for the receipt

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

Line 1204: l_header_id cst_rcv_acq_costs.header_id%TYPE;

1200: l_rec_ct NUMBER;
1201: l_rct_adj_landed_cost NUMBER;
1202: l_lcm_acq_cost NUMBER;
1203: l_net_qty_rec rcv_transactions.quantity%TYPE := 0;
1204: l_header_id cst_rcv_acq_costs.header_id%TYPE;
1205: l_nr_tax_rate NUMBER;
1206: l_primary_uom mtl_system_items.primary_uom_code%TYPE;
1207: l_po_uom mtl_units_of_measure.uom_code%TYPE;
1208: l_po_uom_code po_lines_all.unit_meas_lookup_code%TYPE;

Line 1218: FROM cst_rcv_acq_costs crac

1214: BEGIN
1215: l_stmt_num := 1000;
1216: SELECT count(rcv_transaction_id)
1217: INTO l_rec_ct
1218: FROM cst_rcv_acq_costs crac
1219: WHERE crac.rcv_transaction_id = c_rec.transaction_id
1220: AND crac.period_id = i_period
1221: AND crac.cost_type_id = i_cost_type_id
1222: AND crac.cost_group_id = i_cost_group_id

Line 1270: SELECT cst_rcv_acq_costs_s.nextval

1266: RAISE CST_FAIL_GET_NQR;
1267: END IF;
1268:
1269: l_stmt_num := 1040;
1270: SELECT cst_rcv_acq_costs_s.nextval
1271: INTO l_header_id
1272: FROM dual;
1273:
1274: l_stmt_num := 1050;

Line 1435: l_header_id cst_rcv_acq_costs.header_id%TYPE;

1431: l_exp_acct_id NUMBER;
1432: l_new_landed_cost NUMBER;
1433: l_prior_landed_cost NUMBER;
1434: l_prior_period NUMBER;
1435: l_header_id cst_rcv_acq_costs.header_id%TYPE;
1436: l_exp_account_id NUMBER;
1437: l_transaction_id NUMBER;
1438: l_rcv_accounting_event_id NUMBER;
1439: l_dr_flag BOOLEAN;

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

1597: IF (l_prior_landed_cost = -1) THEN
1598: l_stmt_num := 1190;
1599: SELECT nvl(max(crac3.acquisition_cost),-1)
1600: INTO l_prior_landed_cost
1601: FROM cst_rcv_acq_costs crac3
1602: WHERE crac3.cost_type_id = i_cost_type_id
1603: AND crac3.cost_group_id = i_cost_group_id
1604: AND crac3.rcv_transaction_id = c_rec.rcv_transaction_id;
1605:

Line 1645: SELECT cst_rcv_acq_costs_s.nextval

1641: END IF;
1642: END IF;
1643: IF (l_prior_landed_cost <> l_new_landed_cost) THEN
1644: l_stmt_num := 1210;
1645: SELECT cst_rcv_acq_costs_s.nextval
1646: INTO l_header_id
1647: FROM dual;
1648:
1649: l_stmt_num := 1220;

Line 2299: l_header cst_rcv_acq_costs.header_id%TYPE;

2295: DECLARE
2296: l_rec_ct NUMBER := 0;
2297: l_nqr rcv_transactions.quantity%TYPE := 0;
2298: l_inv_count number;
2299: l_header cst_rcv_acq_costs.header_id%TYPE;
2300: l_primary_uom mtl_system_items.primary_uom_code%TYPE;
2301: l_po_uom mtl_units_of_measure.uom_code%TYPE;
2302: l_po_uom_code po_lines_all.unit_meas_lookup_code%TYPE;
2303: l_po_price po_lines_all.unit_price%TYPE;

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

2394:
2395: -----------------------------------------------------------
2396: -- Get next header id from sequence
2397: -----------------------------------------------------------
2398: SELECT cst_rcv_acq_costs_s.nextval
2399: INTO l_header
2400: FROM dual;
2401:
2402: /* begin changes for dropshipment project */

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

2635: l_po_price := l_po_price * l_poll_quantity / l_pri_poll_quantity;
2636: End if;
2637:
2638: --------------------------------------------------------
2639: -- 2.2 Insert inTO cst_rcV_ACQ_COSTS a row for the receipt
2640: -- for cost type, period, cost group
2641: -- setting quantity_invoiced, quantity_at_po_price,
2642: -- total_invoice_amount, amount_at_po_price, total_amount,
2643: -- costed_quantity, acqcuisition_cost to NULL for now

Line 3736: l_acq_cost cst_rcv_acq_costs.acquisition_cost%TYPE;

3732: l_qty_at_po cst_rcv_acq_cost_details.quantity%TYPE;
3733: l_costed_quantity cst_rcv_acq_cost_details.quantity%TYPE;
3734: l_amount_at_po cst_rcv_acq_cost_details.amount%TYPE;
3735: l_total_amount cst_rcv_acq_cost_details.amount%TYPE;
3736: l_acq_cost cst_rcv_acq_costs.acquisition_cost%TYPE;
3737: l_cracd_count NUMBER := 0;
3738: l_stmt_num NUMBER := 0;
3739: CST_NULL_ACQ_COST EXCEPTION;
3740: BEGIN

Line 3855: cst_rcv_acq_costs crac2

3851:
3852: l_stmt_num := 28;
3853:
3854: UPDATE
3855: cst_rcv_acq_costs crac2
3856: SET
3857: crac2.total_invoice_amount = l_total_invoice_amount,
3858: crac2.total_quantity_invoiced = l_qty_invoiced,
3859: crac2.quantity_at_po_price = l_qty_at_po,

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

4645: nvl(crac3.acquisition_cost,-1)
4646: INTO
4647: l_rec_cost
4648: FROM
4649: cst_rcv_acq_costs crac3
4650: WHERE
4651: crac3.cost_type_id = i_cost_type_id AND
4652: crac3.cost_group_id = i_cost_group_id AND
4653: crac3.rcv_transaction_id = l_par_txn;

Line 4669: cst_rcv_acq_costs crac3

4665: nvl(max(crac3.acquisition_cost),-1)
4666: INTO
4667: l_rec_cost
4668: FROM
4669: cst_rcv_acq_costs crac3
4670: WHERE
4671: crac3.cost_type_id = i_cost_type_id AND
4672: crac3.cost_group_id = i_cost_group_id AND
4673: crac3.rcv_transaction_id = l_par_txn;

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

5059: BEGIN
5060:
5061: If i_source_flag = 1 then
5062:
5063: INSERT INTO cst_rcv_acq_costs (
5064: HEADER_ID,
5065: COST_GROUP_ID,
5066: COST_TYPE_ID,
5067: PERIOD_ID,

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,