APPS.CSTPPIPV dependencies on RCV_TRANSACTIONS

Line 2225: FROM rcv_transactions rt,

2221: trunc(wdj.date_released),
2222: wdj.date_released+0.00001,
2223: rt.transaction_date))
2224: INTO l_transaction_date
2225: FROM rcv_transactions rt,
2226: wip_discrete_jobs wdj
2227: WHERE rt.wip_entity_id = wdj.wip_entity_id (+)
2228: AND rt.transaction_type = 'DELIVER'
2229: AND rt.po_distribution_id = p_po_distribution_id

Line 2232: FROM rcv_transactions rt

2228: AND rt.transaction_type = 'DELIVER'
2229: AND rt.po_distribution_id = p_po_distribution_id
2230: AND rt.transaction_date = (
2231: SELECT MAX(rt.transaction_date)
2232: FROM rcv_transactions rt
2233: WHERE rt.transaction_type = 'DELIVER'
2234: AND rt.po_distribution_id = p_po_distribution_id);
2235:
2236: l_stmt_num := 10;

Line 2251: FROM rcv_transactions rt,

2247: trunc(wdj.date_released),
2248: wdj.date_released+0.00001,
2249: rt.transaction_date))
2250: INTO l_transaction_date
2251: FROM rcv_transactions rt,
2252: po_distributions_all pda,
2253: wip_discrete_jobs wdj
2254: WHERE pda.wip_entity_id = wdj.wip_entity_id (+)
2255: AND pda.po_distribution_id = p_po_distribution_id

Line 2262: FROM rcv_transactions rt,

2258: OR ( rt.po_line_location_id = pda.line_location_id
2259: ))
2260: AND rt.transaction_date = (
2261: SELECT MAX(rt.transaction_date)
2262: FROM rcv_transactions rt,
2263: po_distributions_all pda
2264: WHERE rt.transaction_type = 'RECEIVE'
2265: AND pda.po_distribution_id = p_po_distribution_id
2266: AND ( rt.po_distribution_id = p_po_distribution_id /* bug 4137765 - for performance improvement */