290: --SELECT distinct ACCOUNTING_METHOD
291: --INTO ACCOUNTING_METHOD
292: --FROM ar_system_parameters;
293:
294: XLA_MO_REPORTING_API.Initialize(var.p_reporting_level, var.p_reporting_entity_id, 'AUTO');
295:
296: L_CUST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CUST',NULL);
297: L_PAY_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('PAY',NULL);
298: L_ADJ_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('ADJ',NULL);
292: --FROM ar_system_parameters;
293:
294: XLA_MO_REPORTING_API.Initialize(var.p_reporting_level, var.p_reporting_entity_id, 'AUTO');
295:
296: L_CUST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CUST',NULL);
297: L_PAY_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('PAY',NULL);
298: L_ADJ_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('ADJ',NULL);
299: L_TRX_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('TRX',NULL);
300:
293:
294: XLA_MO_REPORTING_API.Initialize(var.p_reporting_level, var.p_reporting_entity_id, 'AUTO');
295:
296: L_CUST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CUST',NULL);
297: L_PAY_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('PAY',NULL);
298: L_ADJ_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('ADJ',NULL);
299: L_TRX_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('TRX',NULL);
300:
301: --Bug fix 5595083 starts
294: XLA_MO_REPORTING_API.Initialize(var.p_reporting_level, var.p_reporting_entity_id, 'AUTO');
295:
296: L_CUST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CUST',NULL);
297: L_PAY_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('PAY',NULL);
298: L_ADJ_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('ADJ',NULL);
299: L_TRX_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('TRX',NULL);
300:
301: --Bug fix 5595083 starts
302: L_SYSPARAM_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('SYSPARAM',NULL);
295:
296: L_CUST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CUST',NULL);
297: L_PAY_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('PAY',NULL);
298: L_ADJ_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('ADJ',NULL);
299: L_TRX_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('TRX',NULL);
300:
301: --Bug fix 5595083 starts
302: L_SYSPARAM_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('SYSPARAM',NULL);
303: acct_stmt := 'select distinct ACCOUNTING_METHOD FROM ar_system_parameters_all SYSPARAM where ACCOUNTING_METHOD is not null ' || L_SYSPARAM_ORG_WHERE ;
298: L_ADJ_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('ADJ',NULL);
299: L_TRX_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('TRX',NULL);
300:
301: --Bug fix 5595083 starts
302: L_SYSPARAM_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('SYSPARAM',NULL);
303: acct_stmt := 'select distinct ACCOUNTING_METHOD FROM ar_system_parameters_all SYSPARAM where ACCOUNTING_METHOD is not null ' || L_SYSPARAM_ORG_WHERE ;
304: IF var.p_reporting_level = 3000 then
305: IF var.p_reporting_entity_id IS NOT NULL THEN
306: execute immediate acct_stmt into ACCOUNTING_METHOD using var.p_reporting_entity_id, var.p_reporting_entity_id;
462: val => BILL_FLAG );
463: IF (BILL_FLAG = 'Y') THEN
464: SHOW_BILL_WHERE := 'AND pay.cons_inv_id = ci.cons_inv_id(+)';
465: SHOW_BILL_FROM := ', ar_cons_inv_all ci ';
466: L_CI_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('CI',NULL);
467: ELSE
468: SHOW_BILL_WHERE := NULL;
469: SHOW_BILL_FROM := NULL;
470: L_CI_ORG_WHERE := NULL;