APPS.JAI_AP_RPT_PRRG_PKG dependencies on PO_DISTRIBUTIONS_ALL

Line 104: from po_distributions_all

100: trunc(creation_date) po_date
101: from po_headers_all
102: where po_header_id =
103: ( select po_header_id
104: from po_distributions_all
105: where po_distribution_id = p_po_distribution_id);
106:
107: cursor c_get_po_release (p_po_distribution_id number) is
108: select release_num, release_date

Line 117: from po_distributions_all

113: from po_line_locations_all
114: where (po_header_id, po_line_id, line_location_id ) in
115: (
116: select po_header_id, po_line_id, line_location_id
117: from po_distributions_all
118: where po_distribution_id = p_po_distribution_id
119: )
120: );
121:

Line 151: from po_distributions_all

147: and (po_header_id, po_line_id, line_location_id)
148: in
149: (
150: select po_header_id, po_line_id, line_location_id
151: from po_distributions_all
152: where po_distribution_id = p_po_distribution_id
153: );
154:
155: cursor c_get_tax_type(p_tax_id number) is

Line 201: from po_distributions_all

197: and (po_header_id, po_line_id, line_location_id)
198: in
199: (
200: select po_header_id, po_line_id, line_location_id
201: from po_distributions_all
202: where po_distribution_id = p_po_distribution_id
203: )
204: )
205: AND A.tax_id = B.tax_id -- Added by Kevin Cheng for Inclusive Tax

Line 223: from po_distributions_all

219: from JAI_PO_TAXES A, JAI_CMN_TAXES_ALL B -- Added by Kevin Cheng for Inclusive Tax
220: where (A.po_header_id, A.po_line_id, A.line_location_id)
221: in
222: (select po_header_id, po_line_id, line_location_id
223: from po_distributions_all
224: where po_distribution_id = p_po_distribution_id)
225: and A.tax_id not in
226: (
227: select tax_id

Line 242: from po_distributions_all

238: and (po_header_id, po_line_id, line_location_id)
239: in
240: (
241: select po_header_id, po_line_id, line_location_id
242: from po_distributions_all
243: where po_distribution_id = p_po_distribution_id
244: )
245: )
246: AND A.tax_id = B.tax_id -- Added by Kevin Cheng for Inclusive Tax