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 988: FROM jg_zz_vat_trx_details JG

984: , p_ex_vat_trx_type IN VARCHAR2)
985: IS
986: SELECT JG.tax_rate_vat_trx_type_code VAT_TRX_TYPE_CODE,
987: JG.trx_id TRX_ID
988: FROM jg_zz_vat_trx_details JG
989: , jg_zz_vat_rep_status JGR
990: , jg_zz_vat_rep_entities JGVRE
991: , gl_periods glp
992: WHERE JGR.vat_reporting_entity_id = P_VAT_REP_ENTITY_ID

Line 1046: FROM jg_zz_vat_trx_details JG

1042: , JG.trx_line_class CLASS_CODE
1043: , JG.trx_number RECEIPT_NUMBER
1044: , JG.ar_cash_receipt_reverse_date REV_DATE
1045: , JG.ar_cash_receipt_reverse_status STATUS
1046: FROM jg_zz_vat_trx_details JG
1047: , jg_zz_vat_rep_status JGR
1048: WHERE JGR.vat_reporting_entity_id = P_VAT_REP_ENTITY_ID
1049: AND JG.reporting_status_id = JGR.reporting_status_id
1050: AND JGR.tax_calendar_period = P_PERIOD