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 1514: Delete from cst_rcv_acq_cost_details_adj cracda

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

Line 1683: INSERT INTO cst_rcv_acq_cost_details_adj (

1679: o_err_num => l_err_num,
1680: o_err_msg => l_err_msg );
1681:
1682: l_stmt_num := 1230;
1683: INSERT INTO cst_rcv_acq_cost_details_adj (
1684: HEADER_ID,
1685: DETAIL_ID,
1686: SOURCE_TYPE,
1687: PO_LINE_LOCATION_ID,

Line 2345: Delete from cst_rcv_acq_cost_details_adj cracda

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

Line 3567: cst_rcv_acq_cost_details_adj ( -- cracd2

3563: charge, just examine whether the charge_applicable_to_dist_id is not null
3564: */
3565:
3566: INSERT INTO
3567: cst_rcv_acq_cost_details_adj ( -- cracd2
3568: HEADER_ID,
3569: DETAIL_ID,
3570: SOURCE_TYPE,
3571: PO_LINE_LOCATION_ID,

Line 3646: cst_rcv_acq_cost_details_adj cracd3

3642: ----------------------------------------------------------
3643:
3644:
3645: UPDATE
3646: cst_rcv_acq_cost_details_adj cracd3
3647: SET
3648: cracd3.parent_amount = (
3649: SELECT
3650: nvl(ad7.base_amount,nvl(ad7.amount,0))

Line 3684: cst_rcv_acq_cost_details_adj cracd4

3680:
3681: /* bug 4965847 changed query to join with parent_invoice_dist_id rather than parent_distribution_id*/
3682:
3683: UPDATE
3684: cst_rcv_acq_cost_details_adj cracd4
3685: SET
3686: cracd4.amount = cracd4.allocated_amount -- amount in func curr
3687: WHERE
3688: cracd4.header_id = i_hdr AND

Line 3969: l_total_invoice_amount cst_rcv_acq_cost_details_adj.amount%TYPE;

3965: o_err_num OUT NOCOPY NUMBER,
3966: o_err_code OUT NOCOPY VARCHAR2,
3967: o_err_msg OUT NOCOPY VARCHAR2)
3968: IS
3969: l_total_invoice_amount cst_rcv_acq_cost_details_adj.amount%TYPE;
3970: l_qty_invoiced cst_rcv_acq_cost_details_adj.quantity%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;

Line 3970: l_qty_invoiced cst_rcv_acq_cost_details_adj.quantity%TYPE;

3966: o_err_code OUT NOCOPY VARCHAR2,
3967: o_err_msg OUT NOCOPY VARCHAR2)
3968: IS
3969: l_total_invoice_amount cst_rcv_acq_cost_details_adj.amount%TYPE;
3970: l_qty_invoiced cst_rcv_acq_cost_details_adj.quantity%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;

Line 3971: l_qty_at_po cst_rcv_acq_cost_details_adj.quantity%TYPE;

3967: o_err_msg OUT NOCOPY VARCHAR2)
3968: IS
3969: l_total_invoice_amount cst_rcv_acq_cost_details_adj.amount%TYPE;
3970: l_qty_invoiced cst_rcv_acq_cost_details_adj.quantity%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;

Line 3972: l_costed_quantity cst_rcv_acq_cost_details_adj.quantity%TYPE;

3968: IS
3969: l_total_invoice_amount cst_rcv_acq_cost_details_adj.amount%TYPE;
3970: l_qty_invoiced cst_rcv_acq_cost_details_adj.quantity%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;

Line 3973: l_amount_at_po cst_rcv_acq_cost_details_adj.amount%TYPE;

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

Line 3974: l_total_amount cst_rcv_acq_cost_details_adj.amount%TYPE;

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

Line 4030: FROM cst_rcv_acq_cost_details_adj cracd9

4026: -----------------------------------------------------------
4027:
4028: SELECT count(header_id)
4029: INTO l_cracd_count
4030: FROM cst_rcv_acq_cost_details_adj cracd9
4031: WHERE cracd9.header_id = i_header
4032: AND ROWNUM < 2;
4033:
4034: -------------------------------------------------------------

Line 4050: cst_rcv_acq_cost_details_adj cracd10

4046: SUM(cracd10.amount)
4047: INTO
4048: l_total_invoice_amount
4049: FROM
4050: cst_rcv_acq_cost_details_adj cracd10
4051: WHERE
4052: cracd10.header_id = i_header;
4053:
4054: ----------------------------------------------------------

Line 4065: cst_rcv_acq_cost_details_adj cracd11

4061: SUM(nvl(cracd11.quantity,0))
4062: INTO
4063: l_qty_invoiced
4064: FROM
4065: cst_rcv_acq_cost_details_adj cracd11
4066: WHERE
4067: cracd11.header_id = i_header;
4068:
4069: ELSE

Line 4140: cst_rcv_acq_cost_details_adj ( --cracd12

4136:
4137: l_stmt_num := 40;
4138:
4139: INSERT INTO
4140: cst_rcv_acq_cost_details_adj ( --cracd12
4141: HEADER_ID,
4142: DETAIL_ID,
4143: SOURCE_TYPE,
4144: PO_LINE_LOCATION_ID,

Line 5282: Insert into cst_rcv_acq_cost_details_adj(

5278: ELSIF i_source_flag = 2 then
5279:
5280: l_stmt_no := 20;
5281:
5282: Insert into cst_rcv_acq_cost_details_adj(
5283: HEADER_ID,
5284: DETAIL_ID,
5285: SOURCE_TYPE,
5286: PO_LINE_LOCATION_ID,