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_ORDERS_FACT

Line 399: ElsIf pName = 'IBE_ECR_ORDERS_FACT' Then

395:
396: EXECUTE IMMEDIATE 'Create index IBE_ECR_ORDER_HEADERS_FACT_N2 on IBE_ECR_ORDER_HEADERS_FACT(FACT_DATE,INVOICE_TO_ORG_ID)'||l_idx_High_space_clause;
397:
398: EXECUTE IMMEDIATE 'Create UNIQUE index IBE_ECR_ORDER_HEADERS_FACT_U1 on IBE_ECR_ORDER_HEADERS_FACT(HEADER_ID) '||l_idx_High_space_clause;
399: ElsIf pName = 'IBE_ECR_ORDERS_FACT' Then
400:
401: EXECUTE IMMEDIATE 'Create index IBE_ECR_ORDERS_FACT_N1 on IBE_ECR_ORDERS_FACT(ORGANIZATION_ID,INVENTORY_ITEM_ID) '||l_idx_High_space_clause;
402: EXECUTE IMMEDIATE 'Create index IBE_ECR_ORDERS_FACT_N2 on IBE_ECR_ORDERS_FACT(ORG_ID)'||l_idx_High_space_clause;
403: EXECUTE IMMEDIATE 'Create index IBE_ECR_ORDERS_FACT_N3 on IBE_ECR_ORDERS_FACT(FACT_DATE)'||l_idx_High_space_clause;

Line 401: EXECUTE IMMEDIATE 'Create index IBE_ECR_ORDERS_FACT_N1 on IBE_ECR_ORDERS_FACT(ORGANIZATION_ID,INVENTORY_ITEM_ID) '||l_idx_High_space_clause;

397:
398: EXECUTE IMMEDIATE 'Create UNIQUE index IBE_ECR_ORDER_HEADERS_FACT_U1 on IBE_ECR_ORDER_HEADERS_FACT(HEADER_ID) '||l_idx_High_space_clause;
399: ElsIf pName = 'IBE_ECR_ORDERS_FACT' Then
400:
401: EXECUTE IMMEDIATE 'Create index IBE_ECR_ORDERS_FACT_N1 on IBE_ECR_ORDERS_FACT(ORGANIZATION_ID,INVENTORY_ITEM_ID) '||l_idx_High_space_clause;
402: EXECUTE IMMEDIATE 'Create index IBE_ECR_ORDERS_FACT_N2 on IBE_ECR_ORDERS_FACT(ORG_ID)'||l_idx_High_space_clause;
403: EXECUTE IMMEDIATE 'Create index IBE_ECR_ORDERS_FACT_N3 on IBE_ECR_ORDERS_FACT(FACT_DATE)'||l_idx_High_space_clause;
404:
405: /* **** Bug# 4550680 Begin

Line 402: EXECUTE IMMEDIATE 'Create index IBE_ECR_ORDERS_FACT_N2 on IBE_ECR_ORDERS_FACT(ORG_ID)'||l_idx_High_space_clause;

398: EXECUTE IMMEDIATE 'Create UNIQUE index IBE_ECR_ORDER_HEADERS_FACT_U1 on IBE_ECR_ORDER_HEADERS_FACT(HEADER_ID) '||l_idx_High_space_clause;
399: ElsIf pName = 'IBE_ECR_ORDERS_FACT' Then
400:
401: EXECUTE IMMEDIATE 'Create index IBE_ECR_ORDERS_FACT_N1 on IBE_ECR_ORDERS_FACT(ORGANIZATION_ID,INVENTORY_ITEM_ID) '||l_idx_High_space_clause;
402: EXECUTE IMMEDIATE 'Create index IBE_ECR_ORDERS_FACT_N2 on IBE_ECR_ORDERS_FACT(ORG_ID)'||l_idx_High_space_clause;
403: EXECUTE IMMEDIATE 'Create index IBE_ECR_ORDERS_FACT_N3 on IBE_ECR_ORDERS_FACT(FACT_DATE)'||l_idx_High_space_clause;
404:
405: /* **** Bug# 4550680 Begin
406: Removing the code for IBE_ECR_BIN_FACT table.

Line 403: EXECUTE IMMEDIATE 'Create index IBE_ECR_ORDERS_FACT_N3 on IBE_ECR_ORDERS_FACT(FACT_DATE)'||l_idx_High_space_clause;

399: ElsIf pName = 'IBE_ECR_ORDERS_FACT' Then
400:
401: EXECUTE IMMEDIATE 'Create index IBE_ECR_ORDERS_FACT_N1 on IBE_ECR_ORDERS_FACT(ORGANIZATION_ID,INVENTORY_ITEM_ID) '||l_idx_High_space_clause;
402: EXECUTE IMMEDIATE 'Create index IBE_ECR_ORDERS_FACT_N2 on IBE_ECR_ORDERS_FACT(ORG_ID)'||l_idx_High_space_clause;
403: EXECUTE IMMEDIATE 'Create index IBE_ECR_ORDERS_FACT_N3 on IBE_ECR_ORDERS_FACT(FACT_DATE)'||l_idx_High_space_clause;
404:
405: /* **** Bug# 4550680 Begin
406: Removing the code for IBE_ECR_BIN_FACT table.
407: Reason: From R12 release, we are decommissioning the iStore Merchant UI reports.

Line 980: Insert /+ append / into IBE_ECR_ORDERS_FACT (fact_date, object_version_number, created_by, creation_date,

976: printDebugLog('insertOrderLineFact(+)');
977: printDebugLog(fnd_global.tab||'IN Parameters: '||p_currency_code||', '||to_char(pFromDate,'YYYY-MM-DD HH24:MI:SS')||', '||to_char(pToDate,'YYYY-MM-DD HH24:MI:SS') );
978: END IF;
979: /* The following query returns only recordss for type STANDARD, SERVICE and other parent records. */
980: Insert /*+ append */ into IBE_ECR_ORDERS_FACT (fact_date, object_version_number, created_by, creation_date,
981: last_updated_by, last_update_date, last_update_login, resource_id, org_id, msite_id, currency_code, section_id,
982: organization_id, inventory_item_id, uom_code, sold_to_org_id, invoice_to_org_id, agreement_id, salesrep_id,
983: num_times_ordered, sale_quantity, functional_amount, reported_amount) SELECT ift.fact_date Fact_Date,
984: 0 Object_Version_Number,

Line 1321: ElsIf pFactName = 'IBE_ECR_ORDERS_FACT' Then

1317: Commit;
1318:
1319: Delete From IBE_ECR_ORDER_HEADERS_FACT where functional_amount > g_maxamount_ceil;
1320:
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

Line 1465: refreshFact(pMode,'IBE_ECR_ORDERS_FACT',pBeginDate, pEndDate);

1461: Update IBE_ECR_MVLOG Set Refresh_status = -1 Where Refresh_Status = 0;
1462:
1463:
1464: refreshFact(pMode,'IBE_ECR_ORDER_HEADERS_FACT',pBeginDate, pEndDate);
1465: refreshFact(pMode,'IBE_ECR_ORDERS_FACT',pBeginDate, pEndDate);
1466:
1467: /* **** Bug# 4550680 Begin
1468: Removing the code for IBE_ECR_BIN_FACT table.
1469: Reason: From R12 release, we are decommissioning the iStore Merchant UI reports.