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.IBE_REPORTING_PVT dependencies on IBE_ECR_QUOTES_FACT

Line 412: ElsIf pName = 'IBE_ECR_QUOTES_FACT' Then

408: So, IBE_ECR_BIN_FACT table is not required.
409: **** Bug# 4550680 End ***** */
410:
411:
412: ElsIf pName = 'IBE_ECR_QUOTES_FACT' Then
413:
414: EXECUTE IMMEDIATE 'Create index IBE_ECR_QUOTES_FACT_N1 on IBE_ECR_QUOTES_FACT(ORGANIZATION_ID,INVENTORY_ITEM_ID)'||l_idx_High_space_clause;
415: EXECUTE IMMEDIATE 'Create index IBE_ECR_QUOTES_FACT_N2 on IBE_ECR_QUOTES_FACT(ORG_ID)'||l_idx_High_space_clause;
416: EXECUTE IMMEDIATE 'Create index IBE_ECR_QUOTES_FACT_N3 on IBE_ECR_QUOTES_FACT(CUST_ACCOUNT_ID)'||l_idx_High_space_clause;

Line 414: EXECUTE IMMEDIATE 'Create index IBE_ECR_QUOTES_FACT_N1 on IBE_ECR_QUOTES_FACT(ORGANIZATION_ID,INVENTORY_ITEM_ID)'||l_idx_High_space_clause;

410:
411:
412: ElsIf pName = 'IBE_ECR_QUOTES_FACT' Then
413:
414: EXECUTE IMMEDIATE 'Create index IBE_ECR_QUOTES_FACT_N1 on IBE_ECR_QUOTES_FACT(ORGANIZATION_ID,INVENTORY_ITEM_ID)'||l_idx_High_space_clause;
415: EXECUTE IMMEDIATE 'Create index IBE_ECR_QUOTES_FACT_N2 on IBE_ECR_QUOTES_FACT(ORG_ID)'||l_idx_High_space_clause;
416: EXECUTE IMMEDIATE 'Create index IBE_ECR_QUOTES_FACT_N3 on IBE_ECR_QUOTES_FACT(CUST_ACCOUNT_ID)'||l_idx_High_space_clause;
417:
418: End If;

Line 415: EXECUTE IMMEDIATE 'Create index IBE_ECR_QUOTES_FACT_N2 on IBE_ECR_QUOTES_FACT(ORG_ID)'||l_idx_High_space_clause;

411:
412: ElsIf pName = 'IBE_ECR_QUOTES_FACT' Then
413:
414: EXECUTE IMMEDIATE 'Create index IBE_ECR_QUOTES_FACT_N1 on IBE_ECR_QUOTES_FACT(ORGANIZATION_ID,INVENTORY_ITEM_ID)'||l_idx_High_space_clause;
415: EXECUTE IMMEDIATE 'Create index IBE_ECR_QUOTES_FACT_N2 on IBE_ECR_QUOTES_FACT(ORG_ID)'||l_idx_High_space_clause;
416: EXECUTE IMMEDIATE 'Create index IBE_ECR_QUOTES_FACT_N3 on IBE_ECR_QUOTES_FACT(CUST_ACCOUNT_ID)'||l_idx_High_space_clause;
417:
418: End If;
419:

Line 416: EXECUTE IMMEDIATE 'Create index IBE_ECR_QUOTES_FACT_N3 on IBE_ECR_QUOTES_FACT(CUST_ACCOUNT_ID)'||l_idx_High_space_clause;

412: ElsIf pName = 'IBE_ECR_QUOTES_FACT' Then
413:
414: EXECUTE IMMEDIATE 'Create index IBE_ECR_QUOTES_FACT_N1 on IBE_ECR_QUOTES_FACT(ORGANIZATION_ID,INVENTORY_ITEM_ID)'||l_idx_High_space_clause;
415: EXECUTE IMMEDIATE 'Create index IBE_ECR_QUOTES_FACT_N2 on IBE_ECR_QUOTES_FACT(ORG_ID)'||l_idx_High_space_clause;
416: EXECUTE IMMEDIATE 'Create index IBE_ECR_QUOTES_FACT_N3 on IBE_ECR_QUOTES_FACT(CUST_ACCOUNT_ID)'||l_idx_High_space_clause;
417:
418: End If;
419:
420: End If;

Line 540: If pName = 'IBE_ECR_QUOTES_FACT' Then

536: End If;
537:
538: Else
539:
540: If pName = 'IBE_ECR_QUOTES_FACT' Then
541:
542: Delete from IBE_ECR_QUOTES_FACT where quote_date between pFromDate and pToDate;
543:
544: Else

Line 542: Delete from IBE_ECR_QUOTES_FACT where quote_date between pFromDate and pToDate;

538: Else
539:
540: If pName = 'IBE_ECR_QUOTES_FACT' Then
541:
542: Delete from IBE_ECR_QUOTES_FACT where quote_date between pFromDate and pToDate;
543:
544: Else
545:
546: EXECUTE IMMEDIATE 'Delete From '||pName||' Where fact_date between :1 and :2'

Line 1039: Insert /+ append / into IBE_ECR_QUOTES_FACT (quote_date, object_version_number, created_by, creation_date,

1035: printDebugLog('insertQuotesFact(+)');
1036: printDebugLog(fnd_global.tab||'IN Parameters: '||to_char(pFromDate,'YYYY-MM-DD HH24:MI:SS')||', '||to_char(pToDate,'YYYY-MM-DD HH24:MI:SS') );
1037: END IF;
1038:
1039: Insert /*+ append */ into IBE_ECR_QUOTES_FACT (quote_date, object_version_number, created_by, creation_date,
1040: last_updated_by, last_update_date, last_update_login, msite_id, org_id, currency_code, section_id, organization_id,
1041: inventory_item_id, uom_code, cust_account_id, employee_person_id, added_to_cart_frequency, quote_quantity,
1042: item_ordered_frequency, order_quantity)
1043: SELECT

Line 1325: ElsIf pFactName = 'IBE_ECR_QUOTES_FACT' Then

1321: ElsIf pFactName = 'IBE_ECR_ORDERS_FACT' Then
1322:
1323: insertOrderLineFact(g_CurrencyCode,l_factStartDate, l_factEndDate);
1324:
1325: ElsIf pFactName = 'IBE_ECR_QUOTES_FACT' Then
1326:
1327: insertQuotesFact(l_factStartDate, l_factEndDate);
1328: /* **** Bug# 4550680 Begin
1329: Removing the code for IBE_ECR_BIN_FACT table.

Line 1472: refreshFact(pMode,'IBE_ECR_QUOTES_FACT',pBeginDate, pEndDate);

1468: Removing the code for IBE_ECR_BIN_FACT table.
1469: Reason: From R12 release, we are decommissioning the iStore Merchant UI reports.
1470: So, IBE_ECR_BIN_FACT table is not required.
1471: **** Bug# 4550680 End ***** */
1472: refreshFact(pMode,'IBE_ECR_QUOTES_FACT',pBeginDate, pEndDate);
1473:
1474: IF (l_debug = 'Y') THEN
1475: printDebugLog('refreshFactMain(-)');
1476: END IF;