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.AD_ZD_MVIEW dependencies on FND_CONST

Line 776: l_copy_cmt1 := trim(leading fnd_const.newline from l_cmt1);

772: l_chr varchar2(1);
773: BEGIN
774:
775: -- Trim all the new line, space and tab characters
776: l_copy_cmt1 := trim(leading fnd_const.newline from l_cmt1);
777: l_copy_cmt1 := trim(leading ' ' from l_copy_cmt1);
778: l_copy_cmt1 := trim(leading fnd_const.newline from l_copy_cmt1);
779: l_copy_cmt1 := trim(leading ' ' from l_copy_cmt1);
780: l_copy_cmt1 := trim(leading fnd_const.newline from l_copy_cmt1);

Line 778: l_copy_cmt1 := trim(leading fnd_const.newline from l_copy_cmt1);

774:
775: -- Trim all the new line, space and tab characters
776: l_copy_cmt1 := trim(leading fnd_const.newline from l_cmt1);
777: l_copy_cmt1 := trim(leading ' ' from l_copy_cmt1);
778: l_copy_cmt1 := trim(leading fnd_const.newline from l_copy_cmt1);
779: l_copy_cmt1 := trim(leading ' ' from l_copy_cmt1);
780: l_copy_cmt1 := trim(leading fnd_const.newline from l_copy_cmt1);
781: l_copy_cmt1 := trim(leading ' ' from l_copy_cmt1);
782: l_chr := substr(l_copy_cmt1, 1, 1);

Line 780: l_copy_cmt1 := trim(leading fnd_const.newline from l_copy_cmt1);

776: l_copy_cmt1 := trim(leading fnd_const.newline from l_cmt1);
777: l_copy_cmt1 := trim(leading ' ' from l_copy_cmt1);
778: l_copy_cmt1 := trim(leading fnd_const.newline from l_copy_cmt1);
779: l_copy_cmt1 := trim(leading ' ' from l_copy_cmt1);
780: l_copy_cmt1 := trim(leading fnd_const.newline from l_copy_cmt1);
781: l_copy_cmt1 := trim(leading ' ' from l_copy_cmt1);
782: l_chr := substr(l_copy_cmt1, 1, 1);
783:
784:

Line 908: pos := regexp_instr(text, '[ ('||fnd_const.newline||']');

904: | USING DEFAULT LOCAL ROLLBACK SEGMENT |
905: | USING ENFORCED CONSTRAINTS DISABLE QUERY REWRITE |
906: | AS select t1.a, t1.c, t2.b, t2.d from mv1 t1, mv2 t2 |
907: +---------------------------------------------------------------------*/
908: pos := regexp_instr(text, '[ ('||fnd_const.newline||']');
909:
910: l_tmp := substr(text,1, pos-1);
911: l_tmp := regexp_replace(l_tmp, fnd_const.newline, ' ');
912:

Line 911: l_tmp := regexp_replace(l_tmp, fnd_const.newline, ' ');

907: +---------------------------------------------------------------------*/
908: pos := regexp_instr(text, '[ ('||fnd_const.newline||']');
909:
910: l_tmp := substr(text,1, pos-1);
911: l_tmp := regexp_replace(l_tmp, fnd_const.newline, ' ');
912:
913: splitnameowner(l_tmp, ownerquot, mvnamequot, 0);
914: p_owner := ownerquot;
915: p_mvname := mvnamequot;

Line 961: pos := regexp_instr(text, '([[:space:]]|'||fnd_const.newline||

957: | USING DEFAULT LOCAL ROLLBACK SEGMENT |
958: | USING ENFORCED CONSTRAINTS DISABLE QUERY REWRITE |
959: | AS select t1.a, t1.c, t2.b, t2.d from mv1 t1, mv2 t2 |
960: +---------------------------------------------------------------------*/
961: pos := regexp_instr(text, '([[:space:]]|'||fnd_const.newline||
962: ')?AS('||
963: fnd_const.newline||'|[[:space:]])', 1, 1, 0, 'i');
964:
965: --log(c_module, 'STATEMENT', 'step4 pos = '||pos);

Line 963: fnd_const.newline||'|[[:space:]])', 1, 1, 0, 'i');

959: | AS select t1.a, t1.c, t2.b, t2.d from mv1 t1, mv2 t2 |
960: +---------------------------------------------------------------------*/
961: pos := regexp_instr(text, '([[:space:]]|'||fnd_const.newline||
962: ')?AS('||
963: fnd_const.newline||'|[[:space:]])', 1, 1, 0, 'i');
964:
965: --log(c_module, 'STATEMENT', 'step4 pos = '||pos);
966: --log(c_module, 'STATEMENT', 'regext_instr worked');
967: -- l_cmt1 doesn't really contain only the comment part or attributes

Line 1245: l_pos := regexp_instr(l_part1, '([[:space:]]|'||fnd_const.newline||

1241: | |
1242: | AS |
1243: | select "A","B","C","D" from mv1 |
1244: +--------------------------------------------------------------*/
1245: l_pos := regexp_instr(l_part1, '([[:space:]]|'||fnd_const.newline||
1246: ')?AS('||
1247: fnd_const.newline||'|[[:space:]])', 1, 1, 0, 'i');
1248: if (l_pos > 0)
1249: THEN

Line 1247: fnd_const.newline||'|[[:space:]])', 1, 1, 0, 'i');

1243: | select "A","B","C","D" from mv1 |
1244: +--------------------------------------------------------------*/
1245: l_pos := regexp_instr(l_part1, '([[:space:]]|'||fnd_const.newline||
1246: ')?AS('||
1247: fnd_const.newline||'|[[:space:]])', 1, 1, 0, 'i');
1248: if (l_pos > 0)
1249: THEN
1250: l_colstring := substr(l_part1, 1, l_pos-1);
1251: ELSE