eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JE_ES_WHTAX dependencies on JE_ES_WHTAX

Line 1: PACKAGE BODY JE_ES_WHTAX AS

1: PACKAGE BODY JE_ES_WHTAX AS
2: /* $Header: jeeswhtb.pls 120.15.12010000.3 2008/08/04 12:27:05 vgadde ship $ */
3: PROCEDURE plsqlmsg ( msg IN VARCHAR2) IS
4: BEGIN
5: fnd_file.put_line(fnd_file.output, msg);

Line 869: -- nvl(je_es_whtax.get_awt_net_total(inv.INVOICE_ID),0) net_amount,

865: inv.payment_status_flag,
866: inv.invoice_id,
867: inv.invoice_num,
868: nvl(inv.base_amount,inv.invoice_amount) invoice_amount,
869: -- nvl(je_es_whtax.get_awt_net_total(inv.INVOICE_ID),0) net_amount,
870: nvl(je_es_whtax.get_awt_net_total(inv.INVOICE_ID,inv.legal_entity_id,inv.org_id,dist.accounting_date),0) net_amount,
871: nvl(je_es_whtax.GET_PREPAID_AMOUNT( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) prepaid_amount,
872: nvl(je_es_whtax.GET_AMOUNT_WITHHELD( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) invoice_withheld_amount,
873: decode(seq.name || '-' ||

Line 870: nvl(je_es_whtax.get_awt_net_total(inv.INVOICE_ID,inv.legal_entity_id,inv.org_id,dist.accounting_date),0) net_amount,

866: inv.invoice_id,
867: inv.invoice_num,
868: nvl(inv.base_amount,inv.invoice_amount) invoice_amount,
869: -- nvl(je_es_whtax.get_awt_net_total(inv.INVOICE_ID),0) net_amount,
870: nvl(je_es_whtax.get_awt_net_total(inv.INVOICE_ID,inv.legal_entity_id,inv.org_id,dist.accounting_date),0) net_amount,
871: nvl(je_es_whtax.GET_PREPAID_AMOUNT( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) prepaid_amount,
872: nvl(je_es_whtax.GET_AMOUNT_WITHHELD( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) invoice_withheld_amount,
873: decode(seq.name || '-' ||
874: to_char(inv.doc_sequence_value),'-',null,seq.name || '-' ||

Line 871: nvl(je_es_whtax.GET_PREPAID_AMOUNT( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) prepaid_amount,

867: inv.invoice_num,
868: nvl(inv.base_amount,inv.invoice_amount) invoice_amount,
869: -- nvl(je_es_whtax.get_awt_net_total(inv.INVOICE_ID),0) net_amount,
870: nvl(je_es_whtax.get_awt_net_total(inv.INVOICE_ID,inv.legal_entity_id,inv.org_id,dist.accounting_date),0) net_amount,
871: nvl(je_es_whtax.GET_PREPAID_AMOUNT( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) prepaid_amount,
872: nvl(je_es_whtax.GET_AMOUNT_WITHHELD( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) invoice_withheld_amount,
873: decode(seq.name || '-' ||
874: to_char(inv.doc_sequence_value),'-',null,seq.name || '-' ||
875: to_char(inv.doc_sequence_value)),

Line 872: nvl(je_es_whtax.GET_AMOUNT_WITHHELD( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) invoice_withheld_amount,

868: nvl(inv.base_amount,inv.invoice_amount) invoice_amount,
869: -- nvl(je_es_whtax.get_awt_net_total(inv.INVOICE_ID),0) net_amount,
870: nvl(je_es_whtax.get_awt_net_total(inv.INVOICE_ID,inv.legal_entity_id,inv.org_id,dist.accounting_date),0) net_amount,
871: nvl(je_es_whtax.GET_PREPAID_AMOUNT( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) prepaid_amount,
872: nvl(je_es_whtax.GET_AMOUNT_WITHHELD( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) invoice_withheld_amount,
873: decode(seq.name || '-' ||
874: to_char(inv.doc_sequence_value),'-',null,seq.name || '-' ||
875: to_char(inv.doc_sequence_value)),
876: trunc(inv.invoice_date,'DD'),

Line 878: nvl(je_es_whtax.get_payments_count( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id),0) payments_count,

874: to_char(inv.doc_sequence_value),'-',null,seq.name || '-' ||
875: to_char(inv.doc_sequence_value)),
876: trunc(inv.invoice_date,'DD'),
877: invpay.invoice_payment_id,
878: nvl(je_es_whtax.get_payments_count( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id),0) payments_count,
879: nvl(invpay.payment_base_amount,invpay.amount),
880: nvl(invpay.discount_taken,0),
881: trunc(invpay.accounting_date,'DD'),
882: dist.awt_invoice_payment_id,

Line 980: -- nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID),0),

976: inv.payment_status_flag,
977: inv.invoice_id,
978: inv.invoice_num,
979: nvl(inv.base_amount,inv.invoice_amount) ,
980: -- nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID),0),
981: nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id,dist.accounting_date),0),
982: nvl(je_es_whtax.GET_PREPAID_AMOUNT( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) ,
983: nvl(je_es_whtax.GET_AMOUNT_WITHHELD( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0),
984: decode(seq.name || '-' ||

Line 981: nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id,dist.accounting_date),0),

977: inv.invoice_id,
978: inv.invoice_num,
979: nvl(inv.base_amount,inv.invoice_amount) ,
980: -- nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID),0),
981: nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id,dist.accounting_date),0),
982: nvl(je_es_whtax.GET_PREPAID_AMOUNT( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) ,
983: nvl(je_es_whtax.GET_AMOUNT_WITHHELD( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0),
984: decode(seq.name || '-' ||
985: to_char(inv.doc_sequence_value),'-',null,seq.name || '-' ||

Line 982: nvl(je_es_whtax.GET_PREPAID_AMOUNT( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) ,

978: inv.invoice_num,
979: nvl(inv.base_amount,inv.invoice_amount) ,
980: -- nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID),0),
981: nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id,dist.accounting_date),0),
982: nvl(je_es_whtax.GET_PREPAID_AMOUNT( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) ,
983: nvl(je_es_whtax.GET_AMOUNT_WITHHELD( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0),
984: decode(seq.name || '-' ||
985: to_char(inv.doc_sequence_value),'-',null,seq.name || '-' ||
986: to_char(inv.doc_sequence_value)),

Line 983: nvl(je_es_whtax.GET_AMOUNT_WITHHELD( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0),

979: nvl(inv.base_amount,inv.invoice_amount) ,
980: -- nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID),0),
981: nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id,dist.accounting_date),0),
982: nvl(je_es_whtax.GET_PREPAID_AMOUNT( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) ,
983: nvl(je_es_whtax.GET_AMOUNT_WITHHELD( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0),
984: decode(seq.name || '-' ||
985: to_char(inv.doc_sequence_value),'-',null,seq.name || '-' ||
986: to_char(inv.doc_sequence_value)),
987: trunc(inv.invoice_date,'DD'),

Line 989: nvl(je_es_whtax.get_payments_count( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id),0) ,

985: to_char(inv.doc_sequence_value),'-',null,seq.name || '-' ||
986: to_char(inv.doc_sequence_value)),
987: trunc(inv.invoice_date,'DD'),
988: invpay.invoice_payment_id,
989: nvl(je_es_whtax.get_payments_count( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id),0) ,
990: nvl(invpay.payment_base_amount,invpay.amount),
991: nvl(invpay.discount_taken,0),
992: trunc(invpay.accounting_date,'DD'),
993: dist.awt_invoice_payment_id,

Line 1016: -- nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID),0) net_amount,

1012: inv.payment_status_flag,
1013: inv.invoice_id,
1014: inv.invoice_num,
1015: nvl(inv.base_amount,inv.invoice_amount) invoice_amount,
1016: -- nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID),0) net_amount,
1017: nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id,dist.accounting_date),0) net_amount,
1018: nvl(je_es_whtax.GET_PREPAID_AMOUNT( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) prepaid_amount,
1019: nvl(je_es_whtax.GET_AMOUNT_WITHHELD( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) invoice_withheld_amount,
1020: decode(seq.name || '-' ||

Line 1017: nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id,dist.accounting_date),0) net_amount,

1013: inv.invoice_id,
1014: inv.invoice_num,
1015: nvl(inv.base_amount,inv.invoice_amount) invoice_amount,
1016: -- nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID),0) net_amount,
1017: nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id,dist.accounting_date),0) net_amount,
1018: nvl(je_es_whtax.GET_PREPAID_AMOUNT( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) prepaid_amount,
1019: nvl(je_es_whtax.GET_AMOUNT_WITHHELD( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) invoice_withheld_amount,
1020: decode(seq.name || '-' ||
1021: to_char(inv.doc_sequence_value),'-',null,seq.name || '-' ||

Line 1018: nvl(je_es_whtax.GET_PREPAID_AMOUNT( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) prepaid_amount,

1014: inv.invoice_num,
1015: nvl(inv.base_amount,inv.invoice_amount) invoice_amount,
1016: -- nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID),0) net_amount,
1017: nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id,dist.accounting_date),0) net_amount,
1018: nvl(je_es_whtax.GET_PREPAID_AMOUNT( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) prepaid_amount,
1019: nvl(je_es_whtax.GET_AMOUNT_WITHHELD( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) invoice_withheld_amount,
1020: decode(seq.name || '-' ||
1021: to_char(inv.doc_sequence_value),'-',null,seq.name || '-' ||
1022: to_char(inv.doc_sequence_value)),

Line 1019: nvl(je_es_whtax.GET_AMOUNT_WITHHELD( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) invoice_withheld_amount,

1015: nvl(inv.base_amount,inv.invoice_amount) invoice_amount,
1016: -- nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID),0) net_amount,
1017: nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id,dist.accounting_date),0) net_amount,
1018: nvl(je_es_whtax.GET_PREPAID_AMOUNT( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) prepaid_amount,
1019: nvl(je_es_whtax.GET_AMOUNT_WITHHELD( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) invoice_withheld_amount,
1020: decode(seq.name || '-' ||
1021: to_char(inv.doc_sequence_value),'-',null,seq.name || '-' ||
1022: to_char(inv.doc_sequence_value)),
1023: trunc(inv.invoice_date,'DD'),

Line 1025: nvl(je_es_whtax.get_payments_count( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id),0) payments_count,

1021: to_char(inv.doc_sequence_value),'-',null,seq.name || '-' ||
1022: to_char(inv.doc_sequence_value)),
1023: trunc(inv.invoice_date,'DD'),
1024: invpay.invoice_payment_id,
1025: nvl(je_es_whtax.get_payments_count( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id),0) payments_count,
1026: nvl(invpay.payment_base_amount,invpay.amount),
1027: nvl(invpay.discount_taken,0),
1028: trunc(invpay.accounting_date,'DD'),
1029: dist.awt_invoice_payment_id,

Line 1147: -- nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID),0),

1143: inv.payment_status_flag,
1144: inv.invoice_id,
1145: inv.invoice_num,
1146: nvl(inv.base_amount,inv.invoice_amount) ,
1147: -- nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID),0),
1148: nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id,dist.accounting_date),0),
1149: nvl(je_es_whtax.GET_PREPAID_AMOUNT( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) ,
1150: nvl(je_es_whtax.GET_AMOUNT_WITHHELD( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0),
1151: decode(seq.name || '-' ||

Line 1148: nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id,dist.accounting_date),0),

1144: inv.invoice_id,
1145: inv.invoice_num,
1146: nvl(inv.base_amount,inv.invoice_amount) ,
1147: -- nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID),0),
1148: nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id,dist.accounting_date),0),
1149: nvl(je_es_whtax.GET_PREPAID_AMOUNT( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) ,
1150: nvl(je_es_whtax.GET_AMOUNT_WITHHELD( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0),
1151: decode(seq.name || '-' ||
1152: to_char(inv.doc_sequence_value),'-',null,seq.name || '-' ||

Line 1149: nvl(je_es_whtax.GET_PREPAID_AMOUNT( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) ,

1145: inv.invoice_num,
1146: nvl(inv.base_amount,inv.invoice_amount) ,
1147: -- nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID),0),
1148: nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id,dist.accounting_date),0),
1149: nvl(je_es_whtax.GET_PREPAID_AMOUNT( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) ,
1150: nvl(je_es_whtax.GET_AMOUNT_WITHHELD( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0),
1151: decode(seq.name || '-' ||
1152: to_char(inv.doc_sequence_value),'-',null,seq.name || '-' ||
1153: to_char(inv.doc_sequence_value)),

Line 1150: nvl(je_es_whtax.GET_AMOUNT_WITHHELD( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0),

1146: nvl(inv.base_amount,inv.invoice_amount) ,
1147: -- nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID),0),
1148: nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id,dist.accounting_date),0),
1149: nvl(je_es_whtax.GET_PREPAID_AMOUNT( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) ,
1150: nvl(je_es_whtax.GET_AMOUNT_WITHHELD( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0),
1151: decode(seq.name || '-' ||
1152: to_char(inv.doc_sequence_value),'-',null,seq.name || '-' ||
1153: to_char(inv.doc_sequence_value)),
1154: trunc(inv.invoice_date,'DD'),

Line 1156: nvl(je_es_whtax.get_payments_count( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id),0) ,

1152: to_char(inv.doc_sequence_value),'-',null,seq.name || '-' ||
1153: to_char(inv.doc_sequence_value)),
1154: trunc(inv.invoice_date,'DD'),
1155: invpay.invoice_payment_id,
1156: nvl(je_es_whtax.get_payments_count( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id),0) ,
1157: nvl(invpay.payment_base_amount,invpay.amount),
1158: nvl(invpay.discount_taken,0),
1159: trunc(invpay.accounting_date,'DD'),
1160: dist.awt_invoice_payment_id,

Line 1180: -- nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID),0) net_amount,

1176: inv.payment_status_flag,
1177: inv.invoice_id,
1178: inv.invoice_num,
1179: nvl(inv.base_amount,inv.invoice_amount) invoice_amount,
1180: -- nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID),0) net_amount,
1181: nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id,dist.accounting_date),0) net_amount,
1182: nvl(je_es_whtax.GET_PREPAID_AMOUNT( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) prepaid_amount,
1183: nvl(je_es_whtax.GET_AMOUNT_WITHHELD( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) invoice_withheld_amount,
1184: decode(seq.name || '-' || to_char(inv.doc_sequence_value),'-',null,seq.name || '-' ||

Line 1181: nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id,dist.accounting_date),0) net_amount,

1177: inv.invoice_id,
1178: inv.invoice_num,
1179: nvl(inv.base_amount,inv.invoice_amount) invoice_amount,
1180: -- nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID),0) net_amount,
1181: nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id,dist.accounting_date),0) net_amount,
1182: nvl(je_es_whtax.GET_PREPAID_AMOUNT( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) prepaid_amount,
1183: nvl(je_es_whtax.GET_AMOUNT_WITHHELD( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) invoice_withheld_amount,
1184: decode(seq.name || '-' || to_char(inv.doc_sequence_value),'-',null,seq.name || '-' ||
1185: to_char(inv.doc_sequence_value)),

Line 1182: nvl(je_es_whtax.GET_PREPAID_AMOUNT( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) prepaid_amount,

1178: inv.invoice_num,
1179: nvl(inv.base_amount,inv.invoice_amount) invoice_amount,
1180: -- nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID),0) net_amount,
1181: nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id,dist.accounting_date),0) net_amount,
1182: nvl(je_es_whtax.GET_PREPAID_AMOUNT( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) prepaid_amount,
1183: nvl(je_es_whtax.GET_AMOUNT_WITHHELD( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) invoice_withheld_amount,
1184: decode(seq.name || '-' || to_char(inv.doc_sequence_value),'-',null,seq.name || '-' ||
1185: to_char(inv.doc_sequence_value)),
1186: trunc(inv.invoice_date,'DD'),

Line 1183: nvl(je_es_whtax.GET_AMOUNT_WITHHELD( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) invoice_withheld_amount,

1179: nvl(inv.base_amount,inv.invoice_amount) invoice_amount,
1180: -- nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID),0) net_amount,
1181: nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id,dist.accounting_date),0) net_amount,
1182: nvl(je_es_whtax.GET_PREPAID_AMOUNT( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) prepaid_amount,
1183: nvl(je_es_whtax.GET_AMOUNT_WITHHELD( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) invoice_withheld_amount,
1184: decode(seq.name || '-' || to_char(inv.doc_sequence_value),'-',null,seq.name || '-' ||
1185: to_char(inv.doc_sequence_value)),
1186: trunc(inv.invoice_date,'DD'),
1187: invpay.invoice_payment_id,

Line 1188: nvl(je_es_whtax.get_payments_count( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id),0) payments_count,

1184: decode(seq.name || '-' || to_char(inv.doc_sequence_value),'-',null,seq.name || '-' ||
1185: to_char(inv.doc_sequence_value)),
1186: trunc(inv.invoice_date,'DD'),
1187: invpay.invoice_payment_id,
1188: nvl(je_es_whtax.get_payments_count( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id),0) payments_count,
1189: nvl(invpay.payment_base_amount,invpay.amount),
1190: nvl(invpay.discount_taken,0),
1191: trunc(invpay.accounting_date,'DD'),
1192: dist.awt_invoice_payment_id,

Line 1292: -- nvl(je_es_whtax.get_awt_net_total(inv.INVOICE_ID),0) net_amount,

1288: inv.payment_status_flag,
1289: inv.invoice_id,
1290: inv.invoice_num,
1291: nvl(inv.base_amount,inv.invoice_amount) invoice_amount,
1292: -- nvl(je_es_whtax.get_awt_net_total(inv.INVOICE_ID),0) net_amount,
1293: nvl(je_es_whtax.get_awt_net_total(inv.INVOICE_ID,inv.legal_entity_id,inv.org_id,dist.accounting_date),0) net_amount,
1294: nvl(je_es_whtax.GET_PREPAID_AMOUNT( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) prepaid_amount,
1295: nvl(je_es_whtax.GET_AMOUNT_WITHHELD( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) invoice_withheld_amount,
1296: decode(seq.name || '-' ||

Line 1293: nvl(je_es_whtax.get_awt_net_total(inv.INVOICE_ID,inv.legal_entity_id,inv.org_id,dist.accounting_date),0) net_amount,

1289: inv.invoice_id,
1290: inv.invoice_num,
1291: nvl(inv.base_amount,inv.invoice_amount) invoice_amount,
1292: -- nvl(je_es_whtax.get_awt_net_total(inv.INVOICE_ID),0) net_amount,
1293: nvl(je_es_whtax.get_awt_net_total(inv.INVOICE_ID,inv.legal_entity_id,inv.org_id,dist.accounting_date),0) net_amount,
1294: nvl(je_es_whtax.GET_PREPAID_AMOUNT( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) prepaid_amount,
1295: nvl(je_es_whtax.GET_AMOUNT_WITHHELD( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) invoice_withheld_amount,
1296: decode(seq.name || '-' ||
1297: to_char(inv.doc_sequence_value),'-',null,seq.name || '-' ||

Line 1294: nvl(je_es_whtax.GET_PREPAID_AMOUNT( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) prepaid_amount,

1290: inv.invoice_num,
1291: nvl(inv.base_amount,inv.invoice_amount) invoice_amount,
1292: -- nvl(je_es_whtax.get_awt_net_total(inv.INVOICE_ID),0) net_amount,
1293: nvl(je_es_whtax.get_awt_net_total(inv.INVOICE_ID,inv.legal_entity_id,inv.org_id,dist.accounting_date),0) net_amount,
1294: nvl(je_es_whtax.GET_PREPAID_AMOUNT( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) prepaid_amount,
1295: nvl(je_es_whtax.GET_AMOUNT_WITHHELD( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) invoice_withheld_amount,
1296: decode(seq.name || '-' ||
1297: to_char(inv.doc_sequence_value),'-',null,seq.name || '-' ||
1298: to_char(inv.doc_sequence_value)),

Line 1295: nvl(je_es_whtax.GET_AMOUNT_WITHHELD( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) invoice_withheld_amount,

1291: nvl(inv.base_amount,inv.invoice_amount) invoice_amount,
1292: -- nvl(je_es_whtax.get_awt_net_total(inv.INVOICE_ID),0) net_amount,
1293: nvl(je_es_whtax.get_awt_net_total(inv.INVOICE_ID,inv.legal_entity_id,inv.org_id,dist.accounting_date),0) net_amount,
1294: nvl(je_es_whtax.GET_PREPAID_AMOUNT( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) prepaid_amount,
1295: nvl(je_es_whtax.GET_AMOUNT_WITHHELD( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) invoice_withheld_amount,
1296: decode(seq.name || '-' ||
1297: to_char(inv.doc_sequence_value),'-',null,seq.name || '-' ||
1298: to_char(inv.doc_sequence_value)),
1299: trunc(inv.invoice_date,'DD'),

Line 1301: nvl(je_es_whtax.get_payments_count( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id),0) payments_count,

1297: to_char(inv.doc_sequence_value),'-',null,seq.name || '-' ||
1298: to_char(inv.doc_sequence_value)),
1299: trunc(inv.invoice_date,'DD'),
1300: invpay.invoice_payment_id,
1301: nvl(je_es_whtax.get_payments_count( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id),0) payments_count,
1302: nvl(invpay.payment_base_amount,invpay.amount),
1303: nvl(invpay.discount_taken,0),
1304: trunc(invpay.accounting_date,'DD'),
1305: dist.awt_invoice_payment_id,

Line 1423: -- nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID),0) net_amount,

1419: inv.payment_status_flag,
1420: inv.invoice_id,
1421: inv.invoice_num,
1422: nvl(inv.base_amount,inv.invoice_amount) invoice_amount,
1423: -- nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID),0) net_amount,
1424: nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id,dist.accounting_date),0) net_amount,
1425: nvl(je_es_whtax.GET_PREPAID_AMOUNT( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) prepaid_amount,
1426: nvl(je_es_whtax.GET_AMOUNT_WITHHELD( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) invoice_withheld_amount,
1427: decode(seq.name || '-' ||

Line 1424: nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id,dist.accounting_date),0) net_amount,

1420: inv.invoice_id,
1421: inv.invoice_num,
1422: nvl(inv.base_amount,inv.invoice_amount) invoice_amount,
1423: -- nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID),0) net_amount,
1424: nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id,dist.accounting_date),0) net_amount,
1425: nvl(je_es_whtax.GET_PREPAID_AMOUNT( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) prepaid_amount,
1426: nvl(je_es_whtax.GET_AMOUNT_WITHHELD( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) invoice_withheld_amount,
1427: decode(seq.name || '-' ||
1428: to_char(inv.doc_sequence_value),'-',null,seq.name || '-' ||

Line 1425: nvl(je_es_whtax.GET_PREPAID_AMOUNT( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) prepaid_amount,

1421: inv.invoice_num,
1422: nvl(inv.base_amount,inv.invoice_amount) invoice_amount,
1423: -- nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID),0) net_amount,
1424: nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id,dist.accounting_date),0) net_amount,
1425: nvl(je_es_whtax.GET_PREPAID_AMOUNT( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) prepaid_amount,
1426: nvl(je_es_whtax.GET_AMOUNT_WITHHELD( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) invoice_withheld_amount,
1427: decode(seq.name || '-' ||
1428: to_char(inv.doc_sequence_value),'-',null,seq.name || '-' ||
1429: to_char(inv.doc_sequence_value)),

Line 1426: nvl(je_es_whtax.GET_AMOUNT_WITHHELD( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) invoice_withheld_amount,

1422: nvl(inv.base_amount,inv.invoice_amount) invoice_amount,
1423: -- nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID),0) net_amount,
1424: nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id,dist.accounting_date),0) net_amount,
1425: nvl(je_es_whtax.GET_PREPAID_AMOUNT( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) prepaid_amount,
1426: nvl(je_es_whtax.GET_AMOUNT_WITHHELD( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) invoice_withheld_amount,
1427: decode(seq.name || '-' ||
1428: to_char(inv.doc_sequence_value),'-',null,seq.name || '-' ||
1429: to_char(inv.doc_sequence_value)),
1430: trunc(inv.invoice_date,'DD'),

Line 1432: nvl(je_es_whtax.get_payments_count( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id),0) payments_count,

1428: to_char(inv.doc_sequence_value),'-',null,seq.name || '-' ||
1429: to_char(inv.doc_sequence_value)),
1430: trunc(inv.invoice_date,'DD'),
1431: invpay.invoice_payment_id,
1432: nvl(je_es_whtax.get_payments_count( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id),0) payments_count,
1433: nvl(invpay.payment_base_amount,invpay.amount),
1434: nvl(invpay.discount_taken,0),
1435: trunc(invpay.accounting_date,'DD'),
1436: 0,

Line 1531: -- nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID),0) ,

1527: inv.payment_status_flag,
1528: inv.invoice_id,
1529: inv.invoice_num,
1530: nvl(inv.base_amount,inv.invoice_amount),
1531: -- nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID),0) ,
1532: nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id,dist.accounting_date),0) ,
1533: nvl(je_es_whtax.GET_PREPAID_AMOUNT( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) ,
1534: nvl(je_es_whtax.GET_AMOUNT_WITHHELD( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) ,
1535: decode(seq.name || '-' ||

Line 1532: nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id,dist.accounting_date),0) ,

1528: inv.invoice_id,
1529: inv.invoice_num,
1530: nvl(inv.base_amount,inv.invoice_amount),
1531: -- nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID),0) ,
1532: nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id,dist.accounting_date),0) ,
1533: nvl(je_es_whtax.GET_PREPAID_AMOUNT( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) ,
1534: nvl(je_es_whtax.GET_AMOUNT_WITHHELD( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) ,
1535: decode(seq.name || '-' ||
1536: to_char(inv.doc_sequence_value),'-',null,seq.name || '-' ||

Line 1533: nvl(je_es_whtax.GET_PREPAID_AMOUNT( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) ,

1529: inv.invoice_num,
1530: nvl(inv.base_amount,inv.invoice_amount),
1531: -- nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID),0) ,
1532: nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id,dist.accounting_date),0) ,
1533: nvl(je_es_whtax.GET_PREPAID_AMOUNT( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) ,
1534: nvl(je_es_whtax.GET_AMOUNT_WITHHELD( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) ,
1535: decode(seq.name || '-' ||
1536: to_char(inv.doc_sequence_value),'-',null,seq.name || '-' ||
1537: to_char(inv.doc_sequence_value)),

Line 1534: nvl(je_es_whtax.GET_AMOUNT_WITHHELD( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) ,

1530: nvl(inv.base_amount,inv.invoice_amount),
1531: -- nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID),0) ,
1532: nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id,dist.accounting_date),0) ,
1533: nvl(je_es_whtax.GET_PREPAID_AMOUNT( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) ,
1534: nvl(je_es_whtax.GET_AMOUNT_WITHHELD( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) ,
1535: decode(seq.name || '-' ||
1536: to_char(inv.doc_sequence_value),'-',null,seq.name || '-' ||
1537: to_char(inv.doc_sequence_value)),
1538: trunc(inv.invoice_date,'DD'),

Line 1540: nvl(je_es_whtax.get_payments_count( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id),0),

1536: to_char(inv.doc_sequence_value),'-',null,seq.name || '-' ||
1537: to_char(inv.doc_sequence_value)),
1538: trunc(inv.invoice_date,'DD'),
1539: invpay.invoice_payment_id,
1540: nvl(je_es_whtax.get_payments_count( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id),0),
1541: nvl(invpay.payment_base_amount,invpay.amount),
1542: nvl(invpay.discount_taken,0),
1543: trunc(invpay.accounting_date,'DD'),
1544: 0,

Line 1567: -- nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID),0) net_amount,

1563: inv.payment_status_flag,
1564: inv.invoice_id,
1565: inv.invoice_num,
1566: nvl(inv.base_amount,inv.invoice_amount) invoice_amount,
1567: -- nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID),0) net_amount,
1568: nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id,dist.accounting_date),0) net_amount,
1569: nvl(je_es_whtax.GET_PREPAID_AMOUNT( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) prepaid_amount,
1570: nvl(je_es_whtax.GET_AMOUNT_WITHHELD( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) invoice_withheld_amount,
1571: decode(seq.name || '-' ||

Line 1568: nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id,dist.accounting_date),0) net_amount,

1564: inv.invoice_id,
1565: inv.invoice_num,
1566: nvl(inv.base_amount,inv.invoice_amount) invoice_amount,
1567: -- nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID),0) net_amount,
1568: nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id,dist.accounting_date),0) net_amount,
1569: nvl(je_es_whtax.GET_PREPAID_AMOUNT( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) prepaid_amount,
1570: nvl(je_es_whtax.GET_AMOUNT_WITHHELD( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) invoice_withheld_amount,
1571: decode(seq.name || '-' ||
1572: to_char(inv.doc_sequence_value),'-',null,seq.name || '-' ||

Line 1569: nvl(je_es_whtax.GET_PREPAID_AMOUNT( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) prepaid_amount,

1565: inv.invoice_num,
1566: nvl(inv.base_amount,inv.invoice_amount) invoice_amount,
1567: -- nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID),0) net_amount,
1568: nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id,dist.accounting_date),0) net_amount,
1569: nvl(je_es_whtax.GET_PREPAID_AMOUNT( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) prepaid_amount,
1570: nvl(je_es_whtax.GET_AMOUNT_WITHHELD( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) invoice_withheld_amount,
1571: decode(seq.name || '-' ||
1572: to_char(inv.doc_sequence_value),'-',null,seq.name || '-' ||
1573: to_char(inv.doc_sequence_value)),

Line 1570: nvl(je_es_whtax.GET_AMOUNT_WITHHELD( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) invoice_withheld_amount,

1566: nvl(inv.base_amount,inv.invoice_amount) invoice_amount,
1567: -- nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID),0) net_amount,
1568: nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id,dist.accounting_date),0) net_amount,
1569: nvl(je_es_whtax.GET_PREPAID_AMOUNT( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) prepaid_amount,
1570: nvl(je_es_whtax.GET_AMOUNT_WITHHELD( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) invoice_withheld_amount,
1571: decode(seq.name || '-' ||
1572: to_char(inv.doc_sequence_value),'-',null,seq.name || '-' ||
1573: to_char(inv.doc_sequence_value)),
1574: trunc(inv.invoice_date,'DD'),

Line 1576: nvl(je_es_whtax.get_payments_count( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id),0) payments_count,

1572: to_char(inv.doc_sequence_value),'-',null,seq.name || '-' ||
1573: to_char(inv.doc_sequence_value)),
1574: trunc(inv.invoice_date,'DD'),
1575: invpay.invoice_payment_id,
1576: nvl(je_es_whtax.get_payments_count( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id),0) payments_count,
1577: nvl(invpay.payment_base_amount,invpay.amount),
1578: nvl(invpay.discount_taken,0),
1579: trunc(invpay.accounting_date,'DD'),
1580: 0,

Line 1695: -- nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID),0),

1691: inv.payment_status_flag,
1692: inv.invoice_id,
1693: inv.invoice_num,
1694: nvl(inv.base_amount,inv.invoice_amount),
1695: -- nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID),0),
1696: nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id,dist.accounting_date),0),
1697: nvl(je_es_whtax.GET_PREPAID_AMOUNT( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) ,
1698: nvl(je_es_whtax.GET_AMOUNT_WITHHELD( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) ,
1699: decode(seq.name || '-' ||

Line 1696: nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id,dist.accounting_date),0),

1692: inv.invoice_id,
1693: inv.invoice_num,
1694: nvl(inv.base_amount,inv.invoice_amount),
1695: -- nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID),0),
1696: nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id,dist.accounting_date),0),
1697: nvl(je_es_whtax.GET_PREPAID_AMOUNT( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) ,
1698: nvl(je_es_whtax.GET_AMOUNT_WITHHELD( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) ,
1699: decode(seq.name || '-' ||
1700: to_char(inv.doc_sequence_value),'-',null,seq.name || '-' ||

Line 1697: nvl(je_es_whtax.GET_PREPAID_AMOUNT( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) ,

1693: inv.invoice_num,
1694: nvl(inv.base_amount,inv.invoice_amount),
1695: -- nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID),0),
1696: nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id,dist.accounting_date),0),
1697: nvl(je_es_whtax.GET_PREPAID_AMOUNT( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) ,
1698: nvl(je_es_whtax.GET_AMOUNT_WITHHELD( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) ,
1699: decode(seq.name || '-' ||
1700: to_char(inv.doc_sequence_value),'-',null,seq.name || '-' ||
1701: to_char(inv.doc_sequence_value)),

Line 1698: nvl(je_es_whtax.GET_AMOUNT_WITHHELD( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) ,

1694: nvl(inv.base_amount,inv.invoice_amount),
1695: -- nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID),0),
1696: nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id,dist.accounting_date),0),
1697: nvl(je_es_whtax.GET_PREPAID_AMOUNT( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) ,
1698: nvl(je_es_whtax.GET_AMOUNT_WITHHELD( inv.INVOICE_ID,inv.org_id,inv.legal_entity_id),0) ,
1699: decode(seq.name || '-' ||
1700: to_char(inv.doc_sequence_value),'-',null,seq.name || '-' ||
1701: to_char(inv.doc_sequence_value)),
1702: trunc(inv.invoice_date,'DD'),

Line 1704: nvl(je_es_whtax.get_payments_count(inv.INVOICE_ID,inv.legal_entity_id,inv.org_id),0),

1700: to_char(inv.doc_sequence_value),'-',null,seq.name || '-' ||
1701: to_char(inv.doc_sequence_value)),
1702: trunc(inv.invoice_date,'DD'),
1703: invpay.invoice_payment_id,
1704: nvl(je_es_whtax.get_payments_count(inv.INVOICE_ID,inv.legal_entity_id,inv.org_id),0),
1705: nvl(invpay.payment_base_amount,invpay.amount),
1706: nvl(invpay.discount_taken,0),
1707: trunc(invpay.accounting_date,'DD'),
1708: 0,

Line 1733: -- nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID),0) net_amount,

1729: inv.invoice_id,
1730: inv.invoice_num,
1731: trunc(inv.invoice_date,'DD'),
1732: trunc(dist.accounting_date,'DD'),
1733: -- nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID),0) net_amount,
1734: nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id,dist.accounting_date),0) net_amount,
1735: sum(nvl(dist.base_amount,dist.amount)) withholding_tax_amount,
1736: decode(vs.country,'ES',substr(vs.zip,1,2)||'000','98'||substr(fl.description,1,3)),
1737: vs.city,

Line 1734: nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id,dist.accounting_date),0) net_amount,

1730: inv.invoice_num,
1731: trunc(inv.invoice_date,'DD'),
1732: trunc(dist.accounting_date,'DD'),
1733: -- nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID),0) net_amount,
1734: nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id,dist.accounting_date),0) net_amount,
1735: sum(nvl(dist.base_amount,dist.amount)) withholding_tax_amount,
1736: decode(vs.country,'ES',substr(vs.zip,1,2)||'000','98'||substr(fl.description,1,3)),
1737: vs.city,
1738: awt.tax_rate,

Line 1815: -- nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID),0) ,

1811: inv.invoice_id,
1812: inv.invoice_num,
1813: trunc(inv.invoice_date,'DD'),
1814: trunc(dist.accounting_date,'DD'),
1815: -- nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID),0) ,
1816: nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id,dist.accounting_date),0) ,
1817: decode(vs.country,'ES',substr(vs.zip,1,2)||'000','98'||substr(fl.description,1,3)),
1818: vs.city,
1819: awt.tax_rate,

Line 1816: nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id,dist.accounting_date),0) ,

1812: inv.invoice_num,
1813: trunc(inv.invoice_date,'DD'),
1814: trunc(dist.accounting_date,'DD'),
1815: -- nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID),0) ,
1816: nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id,dist.accounting_date),0) ,
1817: decode(vs.country,'ES',substr(vs.zip,1,2)||'000','98'||substr(fl.description,1,3)),
1818: vs.city,
1819: awt.tax_rate,
1820: awt.tax_name

Line 1838: -- nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID),0) net_amount,

1834: inv.invoice_id,
1835: inv.invoice_num,
1836: trunc(inv.invoice_date,'DD'),
1837: trunc(dist.accounting_date,'DD'),
1838: -- nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID),0) net_amount,
1839: nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id,dist.accounting_date),0) net_amount,
1840: sum(nvl(dist.base_amount,dist.amount)) withholding_tax_amount,
1841: decode(vs.country,'ES',substr(vs.zip,1,2)||'000','98'||substr(fl.description,1,3)),
1842: vs.city,

Line 1839: nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id,dist.accounting_date),0) net_amount,

1835: inv.invoice_num,
1836: trunc(inv.invoice_date,'DD'),
1837: trunc(dist.accounting_date,'DD'),
1838: -- nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID),0) net_amount,
1839: nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id,dist.accounting_date),0) net_amount,
1840: sum(nvl(dist.base_amount,dist.amount)) withholding_tax_amount,
1841: decode(vs.country,'ES',substr(vs.zip,1,2)||'000','98'||substr(fl.description,1,3)),
1842: vs.city,
1843: awt.tax_rate,

Line 1940: -- nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID),0) ,

1936: inv.invoice_id,
1937: inv.invoice_num,
1938: trunc(inv.invoice_date,'DD'),
1939: trunc(dist.accounting_date,'DD'),
1940: -- nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID),0) ,
1941: nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id,dist.accounting_date),0) ,
1942: decode(vs.country,'ES',substr(vs.zip,1,2)||'000','98'||substr(fl.description,1,3)),
1943: vs.city,
1944: awt.tax_rate,

Line 1941: nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id,dist.accounting_date),0) ,

1937: inv.invoice_num,
1938: trunc(inv.invoice_date,'DD'),
1939: trunc(dist.accounting_date,'DD'),
1940: -- nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID),0) ,
1941: nvl(je_es_whtax.get_awt_net_total( inv.INVOICE_ID,inv.legal_entity_id,inv.org_id,dist.accounting_date),0) ,
1942: decode(vs.country,'ES',substr(vs.zip,1,2)||'000','98'||substr(fl.description,1,3)),
1943: vs.city,
1944: awt.tax_rate,
1945: awt.tax_name

Line 2689: END je_es_whtax;

2685: dbmsmsg('Error: '|| substr(SQLERRM(SQLCODE),1,255));
2686: RETCODE := 2;
2687: ERRBUF := 'Error: '|| substr(SQLERRM(SQLCODE),1,255);
2688: end get_data;
2689: END je_es_whtax;