APPS.JAI_AP_RPT_PRRG_PKG dependencies on PO_DISTRIBUTIONS_ALL

Line 109: from po_distributions_all

105: trunc(creation_date) po_date
106: from po_headers_all
107: where po_header_id =
108: ( select po_header_id
109: from po_distributions_all
110: where po_distribution_id = p_po_distribution_id);
111:
112: cursor c_get_po_release (p_po_distribution_id number) is
113: select release_num, release_date

Line 122: from po_distributions_all

118: from po_line_locations_all
119: where (po_header_id, po_line_id, line_location_id ) in
120: (
121: select po_header_id, po_line_id, line_location_id
122: from po_distributions_all
123: where po_distribution_id = p_po_distribution_id
124: )
125: );
126:

Line 156: from po_distributions_all

152: and (po_header_id, po_line_id, line_location_id)
153: in
154: (
155: select po_header_id, po_line_id, line_location_id
156: from po_distributions_all
157: where po_distribution_id = p_po_distribution_id
158: );
159:
160: cursor c_get_tax_type(p_tax_id number) is

Line 206: from po_distributions_all

202: and (po_header_id, po_line_id, line_location_id)
203: in
204: (
205: select po_header_id, po_line_id, line_location_id
206: from po_distributions_all
207: where po_distribution_id = p_po_distribution_id
208: )
209: )
210: AND A.tax_id = B.tax_id -- Added by Kevin Cheng for Inclusive Tax

Line 228: from po_distributions_all

224: from JAI_PO_TAXES A, JAI_CMN_TAXES_ALL B -- Added by Kevin Cheng for Inclusive Tax
225: where (A.po_header_id, A.po_line_id, A.line_location_id)
226: in
227: (select po_header_id, po_line_id, line_location_id
228: from po_distributions_all
229: where po_distribution_id = p_po_distribution_id)
230: and A.tax_id not in
231: (
232: select tax_id

Line 247: from po_distributions_all

243: and (po_header_id, po_line_id, line_location_id)
244: in
245: (
246: select po_header_id, po_line_id, line_location_id
247: from po_distributions_all
248: where po_distribution_id = p_po_distribution_id
249: )
250: )
251: AND A.tax_id = B.tax_id -- Added by Kevin Cheng for Inclusive Tax