APPS.PO_CHORD_WF5 dependencies on PO_RELEASES

Line 73: FROM PO_RELEASES_all POR,

69:
70: BEGIN
71: SELECT DISTINCT 'Y'
72: INTO x_release_control.agent_id
73: FROM PO_RELEASES_all POR,
74: PO_RELEASES_ARCHIVE_all PORA
75: WHERE POR.po_release_id = x_po_release_id
76: AND POR.po_release_id = PORA.po_release_id
77: AND PORA.latest_external_flag (+) = 'Y'

Line 74: PO_RELEASES_ARCHIVE_all PORA

70: BEGIN
71: SELECT DISTINCT 'Y'
72: INTO x_release_control.agent_id
73: FROM PO_RELEASES_all POR,
74: PO_RELEASES_ARCHIVE_all PORA
75: WHERE POR.po_release_id = x_po_release_id
76: AND POR.po_release_id = PORA.po_release_id
77: AND PORA.latest_external_flag (+) = 'Y'
78: AND (

Line 95: FROM PO_RELEASES_all POR,

91:
92: BEGIN
93: SELECT DISTINCT 'Y'
94: INTO x_release_control.acceptance_required_flag
95: FROM PO_RELEASES_all POR,
96: PO_RELEASES_ARCHIVE_all PORA
97: WHERE POR.po_release_id = x_po_release_id
98: AND POR.po_release_id = PORA.po_release_id
99: AND PORA.latest_external_flag (+) = 'Y'

Line 96: PO_RELEASES_ARCHIVE_all PORA

92: BEGIN
93: SELECT DISTINCT 'Y'
94: INTO x_release_control.acceptance_required_flag
95: FROM PO_RELEASES_all POR,
96: PO_RELEASES_ARCHIVE_all PORA
97: WHERE POR.po_release_id = x_po_release_id
98: AND POR.po_release_id = PORA.po_release_id
99: AND PORA.latest_external_flag (+) = 'Y'
100: AND (

Line 117: FROM PO_RELEASES_all POR,

113:
114: BEGIN
115: SELECT DISTINCT 'Y'
116: INTO x_release_control.acceptance_due_date
117: FROM PO_RELEASES_all POR,
118: PO_RELEASES_ARCHIVE_all PORA
119: WHERE POR.po_release_id = x_po_release_id
120: AND POR.po_release_id = PORA.po_release_id
121: AND PORA.latest_external_flag (+) = 'Y'

Line 118: PO_RELEASES_ARCHIVE_all PORA

114: BEGIN
115: SELECT DISTINCT 'Y'
116: INTO x_release_control.acceptance_due_date
117: FROM PO_RELEASES_all POR,
118: PO_RELEASES_ARCHIVE_all PORA
119: WHERE POR.po_release_id = x_po_release_id
120: AND POR.po_release_id = PORA.po_release_id
121: AND PORA.latest_external_flag (+) = 'Y'
122: AND (

Line 139: FROM PO_RELEASES_all POR,

135:
136: BEGIN
137: SELECT DISTINCT 'Y'
138: INTO x_release_control.release_num
139: FROM PO_RELEASES_all POR,
140: PO_RELEASES_ARCHIVE_all PORA
141: WHERE POR.po_release_id = x_po_release_id
142: AND POR.po_release_id = PORA.po_release_id
143: AND PORA.latest_external_flag (+) = 'Y'

Line 140: PO_RELEASES_ARCHIVE_all PORA

136: BEGIN
137: SELECT DISTINCT 'Y'
138: INTO x_release_control.release_num
139: FROM PO_RELEASES_all POR,
140: PO_RELEASES_ARCHIVE_all PORA
141: WHERE POR.po_release_id = x_po_release_id
142: AND POR.po_release_id = PORA.po_release_id
143: AND PORA.latest_external_flag (+) = 'Y'
144: AND (

Line 161: FROM PO_RELEASES_all POR,

157:
158: BEGIN
159: SELECT DISTINCT 'Y'
160: INTO x_release_control.release_date
161: FROM PO_RELEASES_all POR,
162: PO_RELEASES_ARCHIVE_all PORA
163: WHERE POR.po_release_id = x_po_release_id
164: AND POR.po_release_id = PORA.po_release_id
165: AND PORA.latest_external_flag (+) = 'Y'

Line 162: PO_RELEASES_ARCHIVE_all PORA

158: BEGIN
159: SELECT DISTINCT 'Y'
160: INTO x_release_control.release_date
161: FROM PO_RELEASES_all POR,
162: PO_RELEASES_ARCHIVE_all PORA
163: WHERE POR.po_release_id = x_po_release_id
164: AND POR.po_release_id = PORA.po_release_id
165: AND PORA.latest_external_flag (+) = 'Y'
166: AND (

Line 211: FROM po_releases_all PR

207: BEGIN
208:
209: SELECT po_header_id
210: into x_po_header_id
211: FROM po_releases_all PR
212: WHERE PR.po_release_id = x_po_release_id;
213:
214: po_core_s2.get_po_currency (x_po_header_id,
215: x_base_currency,

Line 263: FROM po_releases

259: INTO x_release_total_archive
260: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA,
261: PO_DISTRIBUTIONS_ARCHIVE_ALL PODA
262: WHERE PODA.po_header_id = (SELECT po_header_id
263: FROM po_releases
264: WHERE po_release_id = x_po_release_id)
265: AND POLLA.po_header_id = PODA.po_header_id
266: AND POLLA.po_release_id = x_po_release_id
267: AND POLLA.latest_external_flag (+) = 'Y'

Line 304: FROM po_releases

300: INTO x_release_total_archive
301: FROM PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA,
302: PO_DISTRIBUTIONS_ARCHIVE_ALL PODA
303: WHERE PODA.po_header_id = (SELECT po_header_id
304: FROM po_releases
305: WHERE po_release_id = x_po_release_id)
306: AND POLLA.po_header_id = PODA.po_header_id
307: AND POLLA.po_release_id = x_po_release_id
308: AND POLLA.latest_external_flag (+) = 'Y'