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 2775: AND aia.invoice_type_lookup_code in ('STANDARD','MIXED')

2771: FROM
2772: ap_invoices_all aia
2773: , ap_invoice_lines_all aila
2774: WHERE aia.invoice_id = aila.invoice_id
2775: AND aia.invoice_type_lookup_code in ('STANDARD','MIXED')
2776: AND aia.cancelled_date IS NULL
2777: AND aila.line_type_lookup_code = 'ITEM'
2778: AND aila.match_type = 'ITEM_TO_PO'
2779: AND aila.po_line_location_id = l_movement_transaction.po_line_location_id

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

2942: FROM
2943: ap_invoices_all aia
2944: , ap_invoice_lines_all aila
2945: WHERE aia.invoice_id = aila.invoice_id
2946: AND aia.invoice_type_lookup_code in ('STANDARD','MIXED')
2947: AND aia.cancelled_date IS NULL
2948: AND aila.line_type_lookup_code = 'ITEM'
2949: AND aila.match_type = 'ITEM_TO_RECEIPT'
2950: AND aila.rcv_transaction_id = l_movement_transaction.rcv_transaction_id