APPS.JG_ZZ_SUMMARY_AR_PKG dependencies on JG_ZZ_VAT_TRX_DETAILS

Line 464: FROM jg_zz_vat_trx_details JG

460: IS
461: SELECT JG.trx_id CUSTOMER_TRX_ID
462: , MAX(RPT.apply_date) APPLY_DATE
463: , FND_DATE.CANONICAL_TO_DATE(JG.tax_invoice_date) TAX_INVOICE_DATE
464: FROM jg_zz_vat_trx_details JG
465: , ar_receivable_applications RPT
466: WHERE JG.trx_id = RPT.applied_customer_trx_id
467: AND JG.ledger_id = RPT.set_of_books_id
468: AND RPT.status = 'APP'

Line 474: FROM jg_zz_vat_trx_details JGZZ

470: AND RPT.amount_applied >= 0
471: AND TRUNC(RPT.apply_date) <= TRUNC(P_PERIOD_END_DATE)
472: AND RPT.apply_date < FND_DATE.CANONICAL_TO_DATE(JG.tax_invoice_date)
473: AND NOT EXISTS (SELECT 1
474: FROM jg_zz_vat_trx_details JGZZ
475: WHERE JGZZ.trx_id = JG.trx_id
476: AND JGZZ.tax_invoice_date IS NOT NULL
477: )
478: GROUP BY JG.trx_id

Line 487: UPDATE jg_zz_vat_trx_details JG

483:
484: FOR rec_cust_trx IN lcu_cust_trx
485: LOOP
486: BEGIN
487: UPDATE jg_zz_vat_trx_details JG
488: SET JG.tax_invoice_date = FND_DATE.DATE_TO_CANONICAL(rec_cust_trx.apply_date )
489: WHERE JG.trx_id = rec_cust_trx.customer_trx_id;
490: EXCEPTION
491: WHEN OTHERS THEN

Line 928: FROM jg_zz_vat_trx_details JG

924: , JG.trx_line_class CLASS_CODE
925: , JG.ledger_id LEDGER_ID
926: , JGVRE.enable_report_sequence_flag ENABLE_REPORT_SEQUENCE_FLAG
927: , glp.period_num PERIOD_NUM
928: FROM jg_zz_vat_trx_details JG
929: , jg_zz_vat_rep_status JGR
930: , jg_zz_vat_rep_entities JGVRE
931: , gl_periods glp
932: WHERE JGR.vat_reporting_entity_id = P_VAT_REP_ENTITY_ID

Line 961: FROM jg_zz_vat_trx_details JG

957: , p_ex_vat_trx_type IN VARCHAR2)
958: IS
959: SELECT JG.tax_rate_vat_trx_type_code VAT_TRX_TYPE_CODE,
960: JG.trx_id TRX_ID
961: FROM jg_zz_vat_trx_details JG
962: , jg_zz_vat_rep_status JGR
963: , jg_zz_vat_rep_entities JGVRE
964: , gl_periods glp
965: WHERE JGR.vat_reporting_entity_id = P_VAT_REP_ENTITY_ID

Line 1018: FROM jg_zz_vat_trx_details JG

1014: , JG.trx_line_class CLASS_CODE
1015: , JG.trx_number RECEIPT_NUMBER
1016: , JG.ar_cash_receipt_reverse_date REV_DATE
1017: , JG.ar_cash_receipt_reverse_status STATUS
1018: FROM jg_zz_vat_trx_details JG
1019: , jg_zz_vat_rep_status JGR
1020: WHERE JGR.vat_reporting_entity_id = P_VAT_REP_ENTITY_ID
1021: AND JG.reporting_status_id = JGR.reporting_status_id
1022: AND JGR.tax_calendar_period = P_PERIOD