APPS.CSTPPACQ dependencies on CST_LC_ADJ_TRANSACTIONS

Line 276: FROM cst_lc_adj_transactions clat,

272: nvl(rt.po_distribution_id,-1) po_distribution_id,
273: poll.quantity poll_quantity,
274: muom.unit_of_measure,
275: max(clat.transaction_id) transaction_id
276: FROM cst_lc_adj_transactions clat,
277: cst_cost_group_assignments ccga1,
278: mtl_parameters mp,
279: rcv_transactions rt,
280: rcv_parameters rp,

Line 1250: FROM cst_lc_adj_transactions

1246: FROM
1247: (SELECT new_landed_cost,transaction_id,transaction_date,
1248: max(transaction_date) OVER (PARTITION BY rcv_transaction_id)
1249: max_transaction_date
1250: FROM cst_lc_adj_transactions
1251: WHERE rcv_transaction_id = c_rec.transaction_id
1252: AND transaction_date BETWEEN l_start_date
1253: AND l_end_date)
1254: WHERE transaction_date = max_transaction_date

Line 1553: FROM cst_lc_adj_transactions

1549: /* GET NEW LANDED COST*/
1550: l_stmt_num := 1160;
1551: /*SELECT new_landed_cost
1552: INTO l_new_landed_cost
1553: FROM cst_lc_adj_transactions
1554: WHERE transaction_id = c_rec.transaction_id;*/
1555: SELECT Max(new_landed_cost)
1556: INTO l_new_landed_cost
1557: FROM

Line 1566: FROM cst_lc_adj_transactions

1562: FROM
1563: (SELECT new_landed_cost,transaction_id,transaction_date,
1564: max(transaction_date) OVER (PARTITION BY rcv_transaction_id)
1565: max_transaction_date
1566: FROM cst_lc_adj_transactions
1567: WHERE rcv_transaction_id = c_rec.rcv_transaction_id
1568: AND organization_id = c_rec.organization_id
1569: AND transaction_date BETWEEN l_start_date
1570: AND l_end_date)

Line 1617: FROM cst_lc_adj_transactions clat1

1613: IF (l_prior_landed_cost = -1) THEN
1614: l_stmt_num := 1200;
1615: /* SELECT nvl(max(clat1.new_landed_cost),-1)
1616: INTO l_prior_landed_cost
1617: FROM cst_lc_adj_transactions clat1
1618: WHERE clat1.rcv_transaction_id = c_rec.rcv_transaction_id
1619: AND clat1.transaction_date < l_start_date
1620: AND clat1.transaction_id = ( SELECT max(clat2.transaction_id)
1621: FROM cst_lc_adj_transactions clat2

Line 1621: FROM cst_lc_adj_transactions clat2

1617: FROM cst_lc_adj_transactions clat1
1618: WHERE clat1.rcv_transaction_id = c_rec.rcv_transaction_id
1619: AND clat1.transaction_date < l_start_date
1620: AND clat1.transaction_id = ( SELECT max(clat2.transaction_id)
1621: FROM cst_lc_adj_transactions clat2
1622: WHERE clat2.rcv_transaction_id =
1623: c_rec.rcv_transaction_id
1624: AND clat2.transaction_date <
1625: l_start_date

Line 1638: FROM cst_lc_adj_transactions

1634: FROM
1635: (SELECT new_landed_cost,transaction_id,transaction_date,
1636: max(transaction_date) OVER (PARTITION BY rcv_transaction_id)
1637: max_transaction_date
1638: FROM cst_lc_adj_transactions
1639: WHERE rcv_transaction_id = c_rec.rcv_transaction_id
1640: AND transaction_date < l_start_date
1641: )
1642: WHERE transaction_date = max_transaction_date