DBA Data[Home] [Help]

APPS.PO_CHARGES_GRP dependencies on RCV_PARAMETERS

Line 76: rcv_parameters rp,

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
80: AND rt.organization_id = rp.organization_id

Line 94: rcv_parameters rp

90: -- import ASN
91: SELECT rsh.shipment_header_id
92: FROM rcv_shipment_headers rsh,
93: rcv_headers_interface rhi,
94: rcv_parameters rp
95: WHERE rhi.group_id = DECODE(p_group_id, 0, rhi.group_id, p_group_id)
96: AND rsh.shipment_num = rhi.shipment_num
97: AND rsh.request_id = p_request_id
98: AND rsh.receipt_source_code = 'VENDOR'

Line 443: rcv_parameters rp,

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
447: AND rt.transaction_type = 'RECEIVE'