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.FV_BE_INT_PKG dependencies on FV_BUDGET_DISTRIBUTION_DTL

Line 655: ' FROM fv_budget_distribution_dtl

651:
652: l_stmt:=
653: 'SELECT '||app_col_name.application_column_name||'_TYPE,'||
654: app_col_name.application_column_name||
655: ' FROM fv_budget_distribution_dtl
656: WHERE set_of_books_id = :set_of_books_id
657: AND budget_level_id = :budget_level_id
658: AND fund_value = :fund_value ';
659:

Line 725: FROM fv_budget_distribution_dtl

721: := app_col_rec.flex_value_set_id;
722:
723: l_stmt:=
724: 'SELECT '||app_col_rec.application_column_name||'_TYPE
725: FROM fv_budget_distribution_dtl
726: WHERE set_of_books_id = :set_of_books_id
727: AND budget_level_id = :budget_level_id
728: AND fund_value = :fund_value ';
729:

Line 789: FROM fv_budget_distribution_dtl

785: l_seg_type := NULL;
786:
787: l_stmt:=
788: 'SELECT '||app_col_rec.application_column_name||'_TYPE
789: FROM fv_budget_distribution_dtl
790: WHERE set_of_books_id = :set_of_books_id
791: AND budget_level_id = :budget_level_id
792: AND fund_value = :fund_value ';
793:

Line 1000: FROM fv_budget_distribution_dtl

996: l_seg_type := NULL;
997:
998: l_stmt:=
999: 'SELECT '||app_col_rec.application_column_name||'_TYPE
1000: FROM fv_budget_distribution_dtl
1001: WHERE set_of_books_id = :set_of_books_id
1002: AND fund_value = :fund_value
1003: AND budget_level_id =
1004: (SELECT MAX(budget_level_id)

Line 1005: FROM fv_budget_distribution_dtl

1001: WHERE set_of_books_id = :set_of_books_id
1002: AND fund_value = :fund_value
1003: AND budget_level_id =
1004: (SELECT MAX(budget_level_id)
1005: FROM fv_budget_distribution_dtl
1006: WHERE fund_value = :fund_value
1007: AND set_of_books_id = :set_of_books_id
1008: AND budget_level_id < :budget_level_id )';
1009:

Line 1038: ' FROM fv_budget_distribution_dtl

1034: THEN
1035:
1036: l_stmt:=
1037: 'SELECT '||app_col_rec.application_column_name||
1038: ' FROM fv_budget_distribution_dtl
1039: WHERE set_of_books_id = :set_of_books_id
1040: AND fund_value = :fund_value
1041: AND budget_level_id =
1042: (SELECT MAX(budget_level_id)

Line 1043: FROM fv_budget_distribution_dtl

1039: WHERE set_of_books_id = :set_of_books_id
1040: AND fund_value = :fund_value
1041: AND budget_level_id =
1042: (SELECT MAX(budget_level_id)
1043: FROM fv_budget_distribution_dtl
1044: WHERE fund_value = :fund_value
1045: AND set_of_books_id = :set_of_books_id
1046: AND budget_level_id < :budget_level_id )';
1047:

Line 1256: ' FROM fv_budget_distribution_dtl

1252:
1253: l_stmt:=
1254: 'SELECT '||app_col_name.application_column_name||'_TYPE,'||
1255: app_col_name.application_column_name||
1256: ' FROM fv_budget_distribution_dtl
1257: WHERE set_of_books_id = :set_of_books_id
1258: AND budget_level_id = :budget_level_id
1259: AND fund_value = :fund_value ';
1260:

Line 1459: FROM fv_budget_distribution_dtl

1455: l_seg_type := NULL;
1456:
1457: l_stmt:=
1458: 'SELECT '||app_col_rec.application_column_name||'_TYPE
1459: FROM fv_budget_distribution_dtl
1460: WHERE set_of_books_id = :set_of_books_id
1461: AND fund_value = :fund_value
1462: AND budget_level_id =
1463: (SELECT MAX(budget_level_id)

Line 1464: FROM fv_budget_distribution_dtl

1460: WHERE set_of_books_id = :set_of_books_id
1461: AND fund_value = :fund_value
1462: AND budget_level_id =
1463: (SELECT MAX(budget_level_id)
1464: FROM fv_budget_distribution_dtl
1465: WHERE fund_value = :fund_value
1466: AND set_of_books_id = :set_of_books_id
1467: AND budget_level_id < :budget_level_id )';
1468:

Line 1483: ' FROM fv_budget_distribution_dtl

1479: THEN
1480:
1481: l_stmt:=
1482: 'SELECT '||app_col_rec.application_column_name||
1483: ' FROM fv_budget_distribution_dtl
1484: WHERE set_of_books_id = :set_of_books_id
1485: AND fund_value = :fund_value
1486: AND budget_level_id =
1487: (SELECT MAX(budget_level_id)

Line 1488: FROM fv_budget_distribution_dtl

1484: WHERE set_of_books_id = :set_of_books_id
1485: AND fund_value = :fund_value
1486: AND budget_level_id =
1487: (SELECT MAX(budget_level_id)
1488: FROM fv_budget_distribution_dtl
1489: WHERE fund_value = :fund_value
1490: AND set_of_books_id = :set_of_books_id
1491: AND budget_level_id < :budget_level_id )';
1492:

Line 1539: -- FROM fv_budget_distribution_dtl

1535: AND fbd.budgeting_segments = valid_rec.budgeting_segments
1536: AND rownum < 2
1537: AND fbh.budget_level_id =
1538: (SELECT MAX(budget_level_id)
1539: -- FROM fv_budget_distribution_dtl
1540: FROM fv_be_trx_dtls
1541: WHERE fund_value = valid_rec.fund_value
1542: AND set_of_books_id = valid_rec.set_of_books_id
1543: AND budget_level_id < valid_rec.budget_level_id

Line 2036: FROM fv_budget_distribution_dtl fbd

2032: BEGIN
2033: l_module_name := g_module_name || 'validate_fund_value';
2034: SELECT 'x'
2035: INTO v_exists
2036: FROM fv_budget_distribution_dtl fbd
2037: WHERE fbd.set_of_books_id = v_set_of_books_id
2038: AND fbd.fund_value = v_fund_value
2039: AND fbd.budget_level_id = v_budget_level_id;
2040: EXCEPTION

Line 2382: ' FROM fv_budget_distribution_dtl

2378:
2379: lv_stmt:=
2380: 'SELECT '||app_col_name.application_column_name||'_TYPE,'||
2381: app_col_name.application_column_name||
2382: ' FROM fv_budget_distribution_dtl
2383: WHERE set_of_books_id = :set_of_books_id
2384: AND budget_level_id = :budget_level_id
2385: AND fund_value = :fund_value ';
2386: