DBA Data[Home] [Help]

APPS.JG_ZZ_JOURNAL_AP_PKG dependencies on STANDARD

Line 464: /* AND JZVTD.trx_line_class IN ('STANDARD','CREDIT','DEBIT','EXPENSE REPORT','PREPAYMENT' ) Bug#5235824 */

460: , jg_zz_vat_box_allocs JZVBA
461: , jg_zz_vat_alloc_rules jzvar
462: WHERE JZVBA.PERIOD_TYPE = 'PERIODIC'
463: AND JZVRS.source = 'AP'
464: /* AND JZVTD.trx_line_class IN ('STANDARD','CREDIT','DEBIT','EXPENSE REPORT','PREPAYMENT' ) Bug#5235824 */
465: AND JZVTD.trx_line_class IN ('STANDARD INVOICES','AP_CREDIT_MEMO','AP_DEBIT_MEMO','EXPENSE REPORTS','PREPAYMENT INVOICES')
466: AND ((JZVTD.billing_tp_name BETWEEN NVL(P_VENDOR_NAME_FROM, JZVTD.billing_tp_name)
467: AND NVL(P_VENDOR_NAME_TO, JZVTD.billing_tp_name)) OR P_VENDOR_NAME_FROM is null)
468: AND ((JZVTD.doc_seq_name BETWEEN NVL(P_DOCUMENT_SEQUENCE_NAME_FROM,JZVTD.doc_seq_name)

Line 465: AND JZVTD.trx_line_class IN ('STANDARD INVOICES','AP_CREDIT_MEMO','AP_DEBIT_MEMO','EXPENSE REPORTS','PREPAYMENT INVOICES')

461: , jg_zz_vat_alloc_rules jzvar
462: WHERE JZVBA.PERIOD_TYPE = 'PERIODIC'
463: AND JZVRS.source = 'AP'
464: /* AND JZVTD.trx_line_class IN ('STANDARD','CREDIT','DEBIT','EXPENSE REPORT','PREPAYMENT' ) Bug#5235824 */
465: AND JZVTD.trx_line_class IN ('STANDARD INVOICES','AP_CREDIT_MEMO','AP_DEBIT_MEMO','EXPENSE REPORTS','PREPAYMENT INVOICES')
466: AND ((JZVTD.billing_tp_name BETWEEN NVL(P_VENDOR_NAME_FROM, JZVTD.billing_tp_name)
467: AND NVL(P_VENDOR_NAME_TO, JZVTD.billing_tp_name)) OR P_VENDOR_NAME_FROM is null)
468: AND ((JZVTD.doc_seq_name BETWEEN NVL(P_DOCUMENT_SEQUENCE_NAME_FROM,JZVTD.doc_seq_name)
469: AND NVL(P_DOCUMENT_SEQUENCE_NAME_TO,JZVTD.doc_seq_name)) OR P_DOCUMENT_SEQUENCE_NAME_FROM IS NULL)