DBA Data[Home] [Help]

APPS.PO_CHARGES_GRP dependencies on RCV_TRANSACTIONS

Line 75: FROM rcv_transactions rt,

71: SELECT shipment_header_id
72: BULK COLLECT INTO l_rsh_id_table
73: FROM (-- po receipts
74: SELECT rt.shipment_header_id
75: FROM rcv_transactions rt,
76: rcv_parameters rp,
77: po_line_locations_all pll -- lcm changes
78: WHERE rt.group_id = DECODE (p_group_id, 0, rt.group_id, p_group_id)
79: AND rt.request_id = p_request_id

Line 442: FROM rcv_transactions rt,

438: x_return_status := FND_API.G_RET_STS_SUCCESS;
439:
440: SELECT DISTINCT shipment_header_id
441: BULK COLLECT INTO l_rsh_id_table
442: FROM rcv_transactions rt,
443: rcv_parameters rp,
444: po_line_locations_all pll -- lcm changes
445: WHERE rt.group_id = decode(p_group_id, 0, rt.group_id, p_group_id)
446: AND rt.request_id = p_request_id -- 0 for online mode