DBA Data[Home] [Help]

APPS.JG_ZZ_JOURNAL_AP_PKG dependencies on STANDARD

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

521: , jg_zz_vat_box_allocs JZVBA
522: , jg_zz_vat_alloc_rules jzvar
523: WHERE JZVBA.PERIOD_TYPE = 'PERIODIC'
524: AND JZVRS.source = 'AP'
525: /* AND JZVTD.trx_line_class IN ('STANDARD','CREDIT','DEBIT','EXPENSE REPORT','PREPAYMENT' ) Bug#5235824 */
526: AND JZVTD.trx_line_class IN ('STANDARD INVOICES','AP_CREDIT_MEMO','AP_DEBIT_MEMO','EXPENSE REPORTS','PREPAYMENT INVOICES','PREPAY_APPLICATION')
527: AND ((JZVTD.billing_tp_name BETWEEN NVL(P_VENDOR_NAME_FROM, JZVTD.billing_tp_name)
528: AND NVL(P_VENDOR_NAME_TO, JZVTD.billing_tp_name)) OR P_VENDOR_NAME_FROM is null)
529: AND ((JZVTD.doc_seq_name BETWEEN NVL(P_DOCUMENT_SEQUENCE_NAME_FROM,JZVTD.doc_seq_name)

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

522: , jg_zz_vat_alloc_rules jzvar
523: WHERE JZVBA.PERIOD_TYPE = 'PERIODIC'
524: AND JZVRS.source = 'AP'
525: /* AND JZVTD.trx_line_class IN ('STANDARD','CREDIT','DEBIT','EXPENSE REPORT','PREPAYMENT' ) Bug#5235824 */
526: AND JZVTD.trx_line_class IN ('STANDARD INVOICES','AP_CREDIT_MEMO','AP_DEBIT_MEMO','EXPENSE REPORTS','PREPAYMENT INVOICES','PREPAY_APPLICATION')
527: AND ((JZVTD.billing_tp_name BETWEEN NVL(P_VENDOR_NAME_FROM, JZVTD.billing_tp_name)
528: AND NVL(P_VENDOR_NAME_TO, JZVTD.billing_tp_name)) OR P_VENDOR_NAME_FROM is null)
529: AND ((JZVTD.doc_seq_name BETWEEN NVL(P_DOCUMENT_SEQUENCE_NAME_FROM,JZVTD.doc_seq_name)
530: AND NVL(P_DOCUMENT_SEQUENCE_NAME_TO,JZVTD.doc_seq_name)) OR P_DOCUMENT_SEQUENCE_NAME_FROM IS NULL)