APPS.CSTPPIPV dependencies on RCV_TRANSACTIONS

Line 2139: FROM rcv_transactions rt,

2135: trunc(wdj.date_released),
2136: wdj.date_released+0.00001,
2137: rt.transaction_date))
2138: INTO l_transaction_date
2139: FROM rcv_transactions rt,
2140: wip_discrete_jobs wdj
2141: WHERE rt.wip_entity_id = wdj.wip_entity_id (+)
2142: AND rt.transaction_type = 'DELIVER'
2143: AND rt.po_distribution_id = p_po_distribution_id

Line 2146: FROM rcv_transactions rt

2142: AND rt.transaction_type = 'DELIVER'
2143: AND rt.po_distribution_id = p_po_distribution_id
2144: AND rt.transaction_date = (
2145: SELECT MAX(rt.transaction_date)
2146: FROM rcv_transactions rt
2147: WHERE rt.transaction_type = 'DELIVER'
2148: AND rt.po_distribution_id = p_po_distribution_id);
2149:
2150: l_stmt_num := 10;

Line 2165: FROM rcv_transactions rt,

2161: trunc(wdj.date_released),
2162: wdj.date_released+0.00001,
2163: rt.transaction_date))
2164: INTO l_transaction_date
2165: FROM rcv_transactions rt,
2166: po_distributions_all pda,
2167: wip_discrete_jobs wdj
2168: WHERE pda.wip_entity_id = wdj.wip_entity_id (+)
2169: AND pda.po_distribution_id = p_po_distribution_id

Line 2176: FROM rcv_transactions rt,

2172: OR ( rt.po_line_location_id = pda.line_location_id
2173: ))
2174: AND rt.transaction_date = (
2175: SELECT MAX(rt.transaction_date)
2176: FROM rcv_transactions rt,
2177: po_distributions_all pda
2178: WHERE rt.transaction_type = 'RECEIVE'
2179: AND pda.po_distribution_id = p_po_distribution_id
2180: AND ( rt.po_distribution_id = p_po_distribution_id /* bug 4137765 - for performance improvement */