176: INTO
177: asset_category_id
178: FROM
179: ap_self_assessed_tax_dist_all sat,
180: po_distributions pod,
181: po_lines pol,
182: financials_system_parameters fsp,
183: mtl_system_items mtlsi
184: WHERE
196: INTO
197: asset_category_id
198: FROM
199: ap_invoice_distributions_all apid,
200: po_distributions pod,
201: po_lines pol,
202: financials_system_parameters fsp,
203: mtl_system_items mtlsi
204: WHERE
219: mtlsi.asset_category_id
220: INTO
221: asset_category_id
222: FROM
223: po_distributions pod,
224: po_lines pol,
225: financials_system_parameters fsp,
226: mtl_system_items mtlsi
227: WHERE
1521: ap_self_assessed_tax_dist_all sat,
1522: ap_batches_all APB ,
1523: po_vendors POV ,
1524: po_headers_all POH ,
1525: po_distributions_all POD
1526: /* Added _all for bug 9253946 */
1527: WHERE API.invoice_id = x_ref2
1528: AND sat.invoice_distribution_id = x_ref3 --bug 7428263
1529: AND sat.invoice_id = API.invoice_id
1556: ap_invoice_distributions_all APID,
1557: ap_batches_all APB ,
1558: po_vendors POV ,
1559: po_headers_all POH ,
1560: po_distributions_all POD
1561: /* Added _all for bug 9253946 */
1562: WHERE API.invoice_id = x_ref2
1563: AND APID.invoice_distribution_id = x_ref3 --bug 7428263
1564: AND APID.invoice_id = API.invoice_id