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_COST_DETAILS_ADJ

Line 1521: Delete from cst_rcv_acq_cost_details_adj cracda

1517: and period_id = i_period
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

Line 1690: INSERT INTO cst_rcv_acq_cost_details_adj (

1686: o_err_num => l_err_num,
1687: o_err_msg => l_err_msg );
1688:
1689: l_stmt_num := 1230;
1690: INSERT INTO cst_rcv_acq_cost_details_adj (
1691: HEADER_ID,
1692: DETAIL_ID,
1693: SOURCE_TYPE,
1694: PO_LINE_LOCATION_ID,

Line 2393: Delete from cst_rcv_acq_cost_details_adj cracda

2389: and craca.cost_type_id = i_cost_type_id );
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

Line 3650: cst_rcv_acq_cost_details_adj ( -- cracd2

3646: charge, just examine whether the charge_applicable_to_dist_id is not null
3647: */
3648:
3649: INSERT INTO
3650: cst_rcv_acq_cost_details_adj ( -- cracd2
3651: HEADER_ID,
3652: DETAIL_ID,
3653: SOURCE_TYPE,
3654: PO_LINE_LOCATION_ID,

Line 3729: cst_rcv_acq_cost_details_adj cracd3

3725: ----------------------------------------------------------
3726:
3727:
3728: UPDATE
3729: cst_rcv_acq_cost_details_adj cracd3
3730: SET
3731: cracd3.parent_amount = (
3732: SELECT
3733: nvl(ad7.base_amount,nvl(ad7.amount,0))

Line 3767: cst_rcv_acq_cost_details_adj cracd4

3763:
3764: /* bug 4965847 changed query to join with parent_invoice_dist_id rather than parent_distribution_id*/
3765:
3766: UPDATE
3767: cst_rcv_acq_cost_details_adj cracd4
3768: SET
3769: cracd4.amount = cracd4.allocated_amount -- amount in func curr
3770: WHERE
3771: cracd4.header_id = i_hdr AND

Line 4052: l_total_invoice_amount cst_rcv_acq_cost_details_adj.amount%TYPE;

4048: o_err_num OUT NOCOPY NUMBER,
4049: o_err_code OUT NOCOPY VARCHAR2,
4050: o_err_msg OUT NOCOPY VARCHAR2)
4051: IS
4052: l_total_invoice_amount cst_rcv_acq_cost_details_adj.amount%TYPE;
4053: l_qty_invoiced cst_rcv_acq_cost_details_adj.quantity%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;

Line 4053: l_qty_invoiced cst_rcv_acq_cost_details_adj.quantity%TYPE;

4049: o_err_code OUT NOCOPY VARCHAR2,
4050: o_err_msg OUT NOCOPY VARCHAR2)
4051: IS
4052: l_total_invoice_amount cst_rcv_acq_cost_details_adj.amount%TYPE;
4053: l_qty_invoiced cst_rcv_acq_cost_details_adj.quantity%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;

Line 4054: l_qty_at_po cst_rcv_acq_cost_details_adj.quantity%TYPE;

4050: o_err_msg OUT NOCOPY VARCHAR2)
4051: IS
4052: l_total_invoice_amount cst_rcv_acq_cost_details_adj.amount%TYPE;
4053: l_qty_invoiced cst_rcv_acq_cost_details_adj.quantity%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;

Line 4055: l_costed_quantity cst_rcv_acq_cost_details_adj.quantity%TYPE;

4051: IS
4052: l_total_invoice_amount cst_rcv_acq_cost_details_adj.amount%TYPE;
4053: l_qty_invoiced cst_rcv_acq_cost_details_adj.quantity%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;

Line 4056: l_amount_at_po cst_rcv_acq_cost_details_adj.amount%TYPE;

4052: l_total_invoice_amount cst_rcv_acq_cost_details_adj.amount%TYPE;
4053: l_qty_invoiced cst_rcv_acq_cost_details_adj.quantity%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;

Line 4057: l_total_amount cst_rcv_acq_cost_details_adj.amount%TYPE;

4053: l_qty_invoiced cst_rcv_acq_cost_details_adj.quantity%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;

Line 4121: FROM cst_rcv_acq_cost_details_adj cracd9

4117: -----------------------------------------------------------
4118:
4119: SELECT count(header_id)
4120: INTO l_cracd_count
4121: FROM cst_rcv_acq_cost_details_adj cracd9
4122: WHERE cracd9.header_id = i_header
4123: AND ROWNUM < 2;
4124:
4125: -------------------------------------------------------------

Line 4141: cst_rcv_acq_cost_details_adj cracd10

4137: SUM(cracd10.amount)
4138: INTO
4139: l_total_invoice_amount
4140: FROM
4141: cst_rcv_acq_cost_details_adj cracd10
4142: WHERE
4143: cracd10.header_id = i_header;
4144:
4145: ----------------------------------------------------------

Line 4156: cst_rcv_acq_cost_details_adj cracd11

4152: SUM(nvl(cracd11.quantity,0))
4153: INTO
4154: l_qty_invoiced
4155: FROM
4156: cst_rcv_acq_cost_details_adj cracd11
4157: WHERE
4158: cracd11.header_id = i_header;
4159:
4160: ELSE

Line 4231: cst_rcv_acq_cost_details_adj ( --cracd12

4227:
4228: l_stmt_num := 40;
4229:
4230: INSERT INTO
4231: cst_rcv_acq_cost_details_adj ( --cracd12
4232: HEADER_ID,
4233: DETAIL_ID,
4234: SOURCE_TYPE,
4235: PO_LINE_LOCATION_ID,

Line 5594: Insert into cst_rcv_acq_cost_details_adj(

5590: ELSIF i_source_flag = 2 then
5591:
5592: l_stmt_no := 20;
5593:
5594: Insert into cst_rcv_acq_cost_details_adj(
5595: HEADER_ID,
5596: DETAIL_ID,
5597: SOURCE_TYPE,
5598: PO_LINE_LOCATION_ID,