APPS.CSTPPACQ dependencies on CST_LC_ADJ_TRANSACTIONS

Line 282: FROM cst_lc_adj_transactions clat,

278: nvl(rt.po_distribution_id,-1) po_distribution_id,
279: poll.quantity poll_quantity,
280: muom.unit_of_measure,
281: max(clat.transaction_id) transaction_id
282: FROM cst_lc_adj_transactions clat,
283: cst_cost_group_assignments ccga1,
284: mtl_parameters mp,
285: rcv_transactions rt,
286: rcv_parameters rp,

Line 1245: FROM cst_lc_adj_transactions

1241: FROM
1242: (SELECT new_landed_cost,transaction_id,transaction_date,
1243: max(transaction_date) OVER (PARTITION BY rcv_transaction_id)
1244: max_transaction_date
1245: FROM cst_lc_adj_transactions
1246: WHERE rcv_transaction_id = c_rec.transaction_id
1247: AND transaction_date BETWEEN l_start_date
1248: AND l_end_date)
1249: WHERE transaction_date = max_transaction_date

Line 1546: FROM cst_lc_adj_transactions

1542: /* GET NEW LANDED COST*/
1543: l_stmt_num := 1160;
1544: /*SELECT new_landed_cost
1545: INTO l_new_landed_cost
1546: FROM cst_lc_adj_transactions
1547: WHERE transaction_id = c_rec.transaction_id;*/
1548: SELECT Max(new_landed_cost)
1549: INTO l_new_landed_cost
1550: FROM

Line 1559: FROM cst_lc_adj_transactions

1555: FROM
1556: (SELECT new_landed_cost,transaction_id,transaction_date,
1557: max(transaction_date) OVER (PARTITION BY rcv_transaction_id)
1558: max_transaction_date
1559: FROM cst_lc_adj_transactions
1560: WHERE rcv_transaction_id = c_rec.rcv_transaction_id
1561: AND organization_id = c_rec.organization_id
1562: AND transaction_date BETWEEN l_start_date
1563: AND l_end_date)

Line 1610: FROM cst_lc_adj_transactions clat1

1606: IF (l_prior_landed_cost = -1) THEN
1607: l_stmt_num := 1200;
1608: /* SELECT nvl(max(clat1.new_landed_cost),-1)
1609: INTO l_prior_landed_cost
1610: FROM cst_lc_adj_transactions clat1
1611: WHERE clat1.rcv_transaction_id = c_rec.rcv_transaction_id
1612: AND clat1.transaction_date < l_start_date
1613: AND clat1.transaction_id = ( SELECT max(clat2.transaction_id)
1614: FROM cst_lc_adj_transactions clat2

Line 1614: FROM cst_lc_adj_transactions clat2

1610: FROM cst_lc_adj_transactions clat1
1611: WHERE clat1.rcv_transaction_id = c_rec.rcv_transaction_id
1612: AND clat1.transaction_date < l_start_date
1613: AND clat1.transaction_id = ( SELECT max(clat2.transaction_id)
1614: FROM cst_lc_adj_transactions clat2
1615: WHERE clat2.rcv_transaction_id =
1616: c_rec.rcv_transaction_id
1617: AND clat2.transaction_date <
1618: l_start_date

Line 1631: FROM cst_lc_adj_transactions

1627: FROM
1628: (SELECT new_landed_cost,transaction_id,transaction_date,
1629: max(transaction_date) OVER (PARTITION BY rcv_transaction_id)
1630: max_transaction_date
1631: FROM cst_lc_adj_transactions
1632: WHERE rcv_transaction_id = c_rec.rcv_transaction_id
1633: AND transaction_date < l_start_date
1634: )
1635: WHERE transaction_date = max_transaction_date