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_ORDER_HEADERS_FACT

Line 392: If pName = 'IBE_ECR_ORDER_HEADERS_FACT' Then

388: l_idx_High_space_clause := ' tablespace '||g_idx_tablespace||' '||l_addOption;
389: l_idx_Low_space_clause := ' tablespace '||g_idx_tablespace||' '||l_addOption;
390:
391:
392: If pName = 'IBE_ECR_ORDER_HEADERS_FACT' Then
393:
394: EXECUTE IMMEDIATE 'Create index IBE_ECR_ORDER_HEADERS_FACT_N1 on IBE_ECR_ORDER_HEADERS_FACT(FACT_DATE) '||l_idx_High_space_clause;
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;

Line 394: EXECUTE IMMEDIATE 'Create index IBE_ECR_ORDER_HEADERS_FACT_N1 on IBE_ECR_ORDER_HEADERS_FACT(FACT_DATE) '||l_idx_High_space_clause;

390:
391:
392: If pName = 'IBE_ECR_ORDER_HEADERS_FACT' Then
393:
394: EXECUTE IMMEDIATE 'Create index IBE_ECR_ORDER_HEADERS_FACT_N1 on IBE_ECR_ORDER_HEADERS_FACT(FACT_DATE) '||l_idx_High_space_clause;
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;

Line 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;

392: If pName = 'IBE_ECR_ORDER_HEADERS_FACT' Then
393:
394: EXECUTE IMMEDIATE 'Create index IBE_ECR_ORDER_HEADERS_FACT_N1 on IBE_ECR_ORDER_HEADERS_FACT(FACT_DATE) '||l_idx_High_space_clause;
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:

Line 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;

394: EXECUTE IMMEDIATE 'Create index IBE_ECR_ORDER_HEADERS_FACT_N1 on IBE_ECR_ORDER_HEADERS_FACT(FACT_DATE) '||l_idx_High_space_clause;
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;

Line 912: Insert /+ append / Into IBE_ECR_ORDER_HEADERS_FACT (fact_date, object_version_number, created_by,creation_date,

908: printDebugLog('insertOrderHeaderFact(+)');
909: 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') );
910: END IF;
911:
912: Insert /*+ append */ Into IBE_ECR_ORDER_HEADERS_FACT (fact_date, object_version_number, created_by,creation_date,
913: last_updated_by, last_update_date, last_update_login, resource_id, org_id, currency_code, header_id, ordered_date,
914: order_number,Transactional_Curr_Code,Conversion_Rate, sold_to_org_id, invoice_to_org_id, agreement_id, salesrep_id,
915: functional_amount, reported_amount, customer_class_code, party_id ) SELECT Trunc(OH.booked_date) Fact_Date,
916: 0 Object_Version_Number,

Line 1011: FROM IBE_ECR_ORDER_HEADERS_FACT ift,

1007: trunc(ift.ordered_date),g_ConversionType,
1008: return_functional_amount(ol.inventory_item_id,osp.Master_Organization_id,ift.header_id,
1009: ol.item_type_code,OL.line_category_code,
1010: OL.ordered_Quantity,OL.Unit_Selling_Price,ift.conversion_rate) ) Reported_Amount
1011: FROM IBE_ECR_ORDER_HEADERS_FACT ift,
1012: OE_ORDER_LINES_ALL OL,
1013: OE_SYSTEM_PARAMETERS_ALL OSP
1014: WHERE ift.Header_id = OL.Header_id
1015: AND ift.fact_date between pFromDate and pToDate

Line 1314: If pFactName = 'IBE_ECR_ORDER_HEADERS_FACT' Then

1310: removeFactData(pMode,pfactName,l_factStartDate,l_factEndDate);
1311:
1312: dropIndex(pMode,'IBE',pfactName);
1313:
1314: If pFactName = 'IBE_ECR_ORDER_HEADERS_FACT' Then
1315:
1316: insertOrderHeaderFact(g_CurrencyCode,l_factStartDate,l_factEndDate);
1317: Commit;
1318:

Line 1319: Delete From IBE_ECR_ORDER_HEADERS_FACT where functional_amount > g_maxamount_ceil;

1315:
1316: insertOrderHeaderFact(g_CurrencyCode,l_factStartDate,l_factEndDate);
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);

Line 1452: CheckRatesAvailable(pMode,'IBE_ECR_ORDER_HEADERS_FACT',pBeginDate, pEndDate,g_maxamount_ceil, l_MissingCount);

1448:
1449: End If;
1450:
1451: if pRateCheckFlag = 'Y' then
1452: CheckRatesAvailable(pMode,'IBE_ECR_ORDER_HEADERS_FACT',pBeginDate, pEndDate,g_maxamount_ceil, l_MissingCount);
1453:
1454: if l_MissingCount > 0 then
1455: raise_application_error(-20205,getMessage('IBE','IBE_ECR_RATES_MISSING_ERR'));
1456: end if;

Line 1464: refreshFact(pMode,'IBE_ECR_ORDER_HEADERS_FACT',pBeginDate, pEndDate);

1460:
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.