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.ARP_PROCESS_CREDIT_UTIL dependencies on RA_CUST_TRX_TYPES

Line 47: ra_cust_trx_types commit_ctt,

43:
44: SELECT sum(amount)
45: INTO l_amount
46: FROM ar_adjustments adj,
47: ra_cust_trx_types commit_ctt,
48: ra_customer_trx commit_trx
49: WHERE commit_ctt.cust_trx_type_id = commit_trx.cust_trx_type_id
50: AND commit_trx.customer_trx_id = p_commit_ct_id
51: AND commit_ctt.type = 'DEP'

Line 124: ra_cust_trx_types commit_ctt,

120: p_line_amount,
121: p_tax_amount,
122: p_freight_amount
123: FROM ar_adjustments adj,
124: ra_cust_trx_types commit_ctt,
125: ra_customer_trx commit_trx
126: WHERE commit_ctt.cust_trx_type_id = commit_trx.cust_trx_type_id
127: AND commit_trx.customer_trx_id = p_commit_ct_id
128: AND commit_ctt.type = 'DEP'

Line 938: ra_cust_trx_types.cust_trx_type_id%type,

934: +===========================================================================*/
935:
936: FUNCTION check_cm_trxtype(
937: p_inv_trx_type_id IN
938: ra_cust_trx_types.cust_trx_type_id%type,
939: p_inv_open_rec_flag IN
940: ra_cust_trx_types.accounting_affect_flag%type,
941: p_cm_trx_type_id IN
942: ra_cust_trx_types.cust_trx_type_id%type

Line 940: ra_cust_trx_types.accounting_affect_flag%type,

936: FUNCTION check_cm_trxtype(
937: p_inv_trx_type_id IN
938: ra_cust_trx_types.cust_trx_type_id%type,
939: p_inv_open_rec_flag IN
940: ra_cust_trx_types.accounting_affect_flag%type,
941: p_cm_trx_type_id IN
942: ra_cust_trx_types.cust_trx_type_id%type
943: )
944: RETURN BOOLEAN IS

Line 942: ra_cust_trx_types.cust_trx_type_id%type

938: ra_cust_trx_types.cust_trx_type_id%type,
939: p_inv_open_rec_flag IN
940: ra_cust_trx_types.accounting_affect_flag%type,
941: p_cm_trx_type_id IN
942: ra_cust_trx_types.cust_trx_type_id%type
943: )
944: RETURN BOOLEAN IS
945: l_dummy char := 'N';
946: BEGIN

Line 950: from ra_cust_trx_types cmctt

946: BEGIN
947: IF P_INV_TRX_TYPE_ID IS NOT NULL Then
948:
949: Select 'Y' Into l_dummy
950: from ra_cust_trx_types cmctt
951: where cmctt.cust_trx_type_id = p_cm_trx_type_id
952: and
953: cmctt.accounting_affect_flag = nvl(p_inv_open_rec_flag,cmctt.accounting_affect_flag) and
954: cmctt.post_to_gl = (select post_to_gl from ra_cust_trx_types invctt

Line 954: cmctt.post_to_gl = (select post_to_gl from ra_cust_trx_types invctt

950: from ra_cust_trx_types cmctt
951: where cmctt.cust_trx_type_id = p_cm_trx_type_id
952: and
953: cmctt.accounting_affect_flag = nvl(p_inv_open_rec_flag,cmctt.accounting_affect_flag) and
954: cmctt.post_to_gl = (select post_to_gl from ra_cust_trx_types invctt
955: where invctt.cust_trx_type_id = p_inv_trx_type_id);
956: End If;
957: Return(TRUE);
958: EXCEPTION

Line 1009: ra_cust_trx_types.cust_trx_type_id%type,

1005: ra_cust_trx_line_gl_dist.gl_date%type,
1006: p_currency_code IN
1007: fnd_currencies.currency_code%type,
1008: p_cust_trx_type_id IN
1009: ra_cust_trx_types.cust_trx_type_id%type,
1010: p_ship_to_customer_id IN
1011: hz_cust_accounts.cust_account_id%type,
1012: p_ship_to_site_use_id IN
1013: hz_cust_site_uses.site_use_id%type,

Line 1054: ra_cust_trx_types.cust_trx_type_id%type,

1050: ra_batch_sources.batch_source_id%type,
1051: p_profile_bs_id IN
1052: ra_batch_sources.batch_source_id%type,
1053: p_crtrx_type_id IN
1054: ra_cust_trx_types.cust_trx_type_id%type,
1055: p_crtrx_cm_type_id IN
1056: ra_cust_trx_types.cust_trx_type_id%type,
1057: p_crtrx_gl_date IN
1058: ra_cust_trx_line_gl_dist.gl_date%type,

Line 1056: ra_cust_trx_types.cust_trx_type_id%type,

1052: ra_batch_sources.batch_source_id%type,
1053: p_crtrx_type_id IN
1054: ra_cust_trx_types.cust_trx_type_id%type,
1055: p_crtrx_cm_type_id IN
1056: ra_cust_trx_types.cust_trx_type_id%type,
1057: p_crtrx_gl_date IN
1058: ra_cust_trx_line_gl_dist.gl_date%type,
1059: p_batch_gl_date IN
1060: ra_batches.gl_date%type,

Line 1077: ra_cust_trx_types.accounting_affect_flag%type,

1073: hz_cust_account_roles.cust_account_role_id%type,
1074: p_crtrx_primary_salesrep_id IN
1075: ra_salesreps.salesrep_id%type,
1076: p_crtrx_open_rec_flag IN
1077: ra_cust_trx_types.accounting_affect_flag%type,
1078: --
1079: p_crtrx_receipt_method_id IN
1080: ar_receipt_methods.receipt_method_id%type,
1081: p_crtrx_cust_bank_account_id IN

Line 1103: ra_cust_trx_types.cust_trx_type_id%type,

1099: ra_batch_sources.batch_source_type%type,
1100: p_copy_doc_number_flag OUT NOCOPY
1101: ra_batch_sources.copy_doc_number_flag%type,
1102: p_bs_default_cust_trx_type_id OUT NOCOPY
1103: ra_cust_trx_types.cust_trx_type_id%type,
1104: p_default_cust_trx_type_id OUT NOCOPY
1105: ra_cust_trx_types.cust_trx_type_id%type,
1106: p_default_type_name OUT NOCOPY
1107: ra_cust_trx_types.name%type,

Line 1105: ra_cust_trx_types.cust_trx_type_id%type,

1101: ra_batch_sources.copy_doc_number_flag%type,
1102: p_bs_default_cust_trx_type_id OUT NOCOPY
1103: ra_cust_trx_types.cust_trx_type_id%type,
1104: p_default_cust_trx_type_id OUT NOCOPY
1105: ra_cust_trx_types.cust_trx_type_id%type,
1106: p_default_type_name OUT NOCOPY
1107: ra_cust_trx_types.name%type,
1108: p_open_receivable_flag OUT NOCOPY
1109: ra_cust_trx_types.accounting_affect_flag%type,

Line 1107: ra_cust_trx_types.name%type,

1103: ra_cust_trx_types.cust_trx_type_id%type,
1104: p_default_cust_trx_type_id OUT NOCOPY
1105: ra_cust_trx_types.cust_trx_type_id%type,
1106: p_default_type_name OUT NOCOPY
1107: ra_cust_trx_types.name%type,
1108: p_open_receivable_flag OUT NOCOPY
1109: ra_cust_trx_types.accounting_affect_flag%type,
1110: p_post_to_gl_flag OUT NOCOPY
1111: ra_cust_trx_types.post_to_gl%type,

Line 1109: ra_cust_trx_types.accounting_affect_flag%type,

1105: ra_cust_trx_types.cust_trx_type_id%type,
1106: p_default_type_name OUT NOCOPY
1107: ra_cust_trx_types.name%type,
1108: p_open_receivable_flag OUT NOCOPY
1109: ra_cust_trx_types.accounting_affect_flag%type,
1110: p_post_to_gl_flag OUT NOCOPY
1111: ra_cust_trx_types.post_to_gl%type,
1112: p_allow_freight_flag OUT NOCOPY
1113: ra_cust_trx_types.allow_freight_flag%type,

Line 1111: ra_cust_trx_types.post_to_gl%type,

1107: ra_cust_trx_types.name%type,
1108: p_open_receivable_flag OUT NOCOPY
1109: ra_cust_trx_types.accounting_affect_flag%type,
1110: p_post_to_gl_flag OUT NOCOPY
1111: ra_cust_trx_types.post_to_gl%type,
1112: p_allow_freight_flag OUT NOCOPY
1113: ra_cust_trx_types.allow_freight_flag%type,
1114: p_creation_sign OUT NOCOPY
1115: ra_cust_trx_types.creation_sign%type,

Line 1113: ra_cust_trx_types.allow_freight_flag%type,

1109: ra_cust_trx_types.accounting_affect_flag%type,
1110: p_post_to_gl_flag OUT NOCOPY
1111: ra_cust_trx_types.post_to_gl%type,
1112: p_allow_freight_flag OUT NOCOPY
1113: ra_cust_trx_types.allow_freight_flag%type,
1114: p_creation_sign OUT NOCOPY
1115: ra_cust_trx_types.creation_sign%type,
1116: p_allow_overapplication_flag OUT NOCOPY
1117: ra_cust_trx_types.allow_overapplication_flag%type,

Line 1115: ra_cust_trx_types.creation_sign%type,

1111: ra_cust_trx_types.post_to_gl%type,
1112: p_allow_freight_flag OUT NOCOPY
1113: ra_cust_trx_types.allow_freight_flag%type,
1114: p_creation_sign OUT NOCOPY
1115: ra_cust_trx_types.creation_sign%type,
1116: p_allow_overapplication_flag OUT NOCOPY
1117: ra_cust_trx_types.allow_overapplication_flag%type,
1118: p_natural_app_only_flag OUT NOCOPY
1119: ra_cust_trx_types.natural_application_only_flag%type,

Line 1117: ra_cust_trx_types.allow_overapplication_flag%type,

1113: ra_cust_trx_types.allow_freight_flag%type,
1114: p_creation_sign OUT NOCOPY
1115: ra_cust_trx_types.creation_sign%type,
1116: p_allow_overapplication_flag OUT NOCOPY
1117: ra_cust_trx_types.allow_overapplication_flag%type,
1118: p_natural_app_only_flag OUT NOCOPY
1119: ra_cust_trx_types.natural_application_only_flag%type,
1120: p_tax_calculation_flag OUT NOCOPY
1121: ra_cust_trx_types.tax_calculation_flag%type,

Line 1119: ra_cust_trx_types.natural_application_only_flag%type,

1115: ra_cust_trx_types.creation_sign%type,
1116: p_allow_overapplication_flag OUT NOCOPY
1117: ra_cust_trx_types.allow_overapplication_flag%type,
1118: p_natural_app_only_flag OUT NOCOPY
1119: ra_cust_trx_types.natural_application_only_flag%type,
1120: p_tax_calculation_flag OUT NOCOPY
1121: ra_cust_trx_types.tax_calculation_flag%type,
1122: p_default_printing_option OUT NOCOPY
1123: ra_customer_trx.printing_option%type,

Line 1121: ra_cust_trx_types.tax_calculation_flag%type,

1117: ra_cust_trx_types.allow_overapplication_flag%type,
1118: p_natural_app_only_flag OUT NOCOPY
1119: ra_cust_trx_types.natural_application_only_flag%type,
1120: p_tax_calculation_flag OUT NOCOPY
1121: ra_cust_trx_types.tax_calculation_flag%type,
1122: p_default_printing_option OUT NOCOPY
1123: ra_customer_trx.printing_option%type,
1124: --
1125: p_default_gl_date OUT NOCOPY

Line 1164: l_bs_default_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;

1160: l_default_bs_name ra_batch_sources.name%type;
1161: l_auto_trx_numbering_flag ra_batch_sources.auto_trx_numbering_flag%type;
1162: l_bs_type ra_batch_sources.batch_source_type%type;
1163: l_copy_doc_number_flag ra_batch_sources.copy_doc_number_flag%type;
1164: l_bs_default_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;
1165: l_default_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;
1166: l_default_status_code ar_lookups.lookup_code%type;
1167: l_default_status ar_lookups.meaning%type;
1168: l_default_printing_option_code ar_lookups.lookup_code%type;

Line 1165: l_default_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;

1161: l_auto_trx_numbering_flag ra_batch_sources.auto_trx_numbering_flag%type;
1162: l_bs_type ra_batch_sources.batch_source_type%type;
1163: l_copy_doc_number_flag ra_batch_sources.copy_doc_number_flag%type;
1164: l_bs_default_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;
1165: l_default_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;
1166: l_default_status_code ar_lookups.lookup_code%type;
1167: l_default_status ar_lookups.meaning%type;
1168: l_default_printing_option_code ar_lookups.lookup_code%type;
1169: l_default_printing_option ar_lookups.meaning%type;

Line 1179: l_default_class ra_cust_trx_types.type%type;

1175: l_ship_to_contact_id hz_cust_account_roles.cust_account_role_id%type;
1176: l_primary_salesrep_id ra_salesreps.salesrep_id%type;
1177: l_number_of_due_dates number;
1178: l_term_due_date date;
1179: l_default_class ra_cust_trx_types.type%type;
1180: l_post_to_gl_flag ra_cust_trx_types.post_to_gl%type;
1181: l_allow_not_open_flag varchar2(1);
1182: l_default_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
1183: l_defaulting_rule_used varchar2(128);

Line 1180: l_post_to_gl_flag ra_cust_trx_types.post_to_gl%type;

1176: l_primary_salesrep_id ra_salesreps.salesrep_id%type;
1177: l_number_of_due_dates number;
1178: l_term_due_date date;
1179: l_default_class ra_cust_trx_types.type%type;
1180: l_post_to_gl_flag ra_cust_trx_types.post_to_gl%type;
1181: l_allow_not_open_flag varchar2(1);
1182: l_default_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
1183: l_defaulting_rule_used varchar2(128);
1184: l_error_message varchar2(128);