DBA Data[Home] [Help]

APPS.INV_MGD_MVT_FIN_MDTR dependencies on STANDARD

Line 35: --| PL/SQL standard for better performance. |

31: --| Calc_Processed_Ret_Data |
32: --| HISTORY |
33: --| 12-03-2002 vma Add code to print to log only if debug profile |
34: --| option is enabled. This is to comply with new |
35: --| PL/SQL standard for better performance. |
36: --| 07-Nov-06 nesoni File is modified for bug 5440432 to calculate |
37: --| invoice correctly for intercompany SO Arrival |
38: --| 22-Jul-07 kdevadas Fix for bug 6035548 - Invoice Details calculated |
39: --| for RMA when selling and shipping orgs are diff. |

Line 2333: AND aia.invoice_type_lookup_code in ('STANDARD','MIXED')

2329: FROM
2330: ap_invoices_all aia
2331: , ap_invoice_lines_all aila
2332: WHERE aia.invoice_id = aila.invoice_id
2333: AND aia.invoice_type_lookup_code in ('STANDARD','MIXED')
2334: AND aia.cancelled_date IS NULL
2335: AND aila.line_type_lookup_code = 'ITEM'
2336: AND aila.match_type = 'ITEM_TO_PO'
2337: AND aila.po_line_location_id = l_movement_transaction.po_line_location_id

Line 2468: AND aia.invoice_type_lookup_code in ('STANDARD','MIXED')

2464: FROM
2465: ap_invoices_all aia
2466: , ap_invoice_lines_all aila
2467: WHERE aia.invoice_id = aila.invoice_id
2468: AND aia.invoice_type_lookup_code in ('STANDARD','MIXED')
2469: AND aia.cancelled_date IS NULL
2470: AND aila.line_type_lookup_code = 'ITEM'
2471: AND aila.match_type = 'ITEM_TO_RECEIPT'
2472: AND aila.rcv_transaction_id = l_movement_transaction.rcv_transaction_id