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.GMI_CMXFER01_XMLP_PKG dependencies on FND_PROFILE

Line 28: LP_FROM_WAREHOUSE := FND_PROFILE.VALUE('SY$ALL');

24: SOURCEWAREHOUSECP := ' and xf.from_warehouse >= ''' || LP_FROM_WAREHOUSE || '''
25: and xf.from_warehouse <= ''' || LP_TO_WAREHOUSE || '''';
26: ELSIF LP_FROM_WAREHOUSE IS NULL AND LP_TO_WAREHOUSE IS NULL THEN
27: SOURCEWAREHOUSECP := ' ';
28: LP_FROM_WAREHOUSE := FND_PROFILE.VALUE('SY$ALL');
29: LP_TO_WAREHOUSE := FND_PROFILE.VALUE('SY$ALL');
30: ELSIF LP_FROM_WAREHOUSE IS NOT NULL AND LP_TO_WAREHOUSE IS NULL THEN
31: SOURCEWAREHOUSECP := ' and xf.from_warehouse >= ''' || LP_FROM_WAREHOUSE || '''';
32: LP_TO_WAREHOUSE := FND_PROFILE.VALUE('SY$ALL');

Line 29: LP_TO_WAREHOUSE := FND_PROFILE.VALUE('SY$ALL');

25: and xf.from_warehouse <= ''' || LP_TO_WAREHOUSE || '''';
26: ELSIF LP_FROM_WAREHOUSE IS NULL AND LP_TO_WAREHOUSE IS NULL THEN
27: SOURCEWAREHOUSECP := ' ';
28: LP_FROM_WAREHOUSE := FND_PROFILE.VALUE('SY$ALL');
29: LP_TO_WAREHOUSE := FND_PROFILE.VALUE('SY$ALL');
30: ELSIF LP_FROM_WAREHOUSE IS NOT NULL AND LP_TO_WAREHOUSE IS NULL THEN
31: SOURCEWAREHOUSECP := ' and xf.from_warehouse >= ''' || LP_FROM_WAREHOUSE || '''';
32: LP_TO_WAREHOUSE := FND_PROFILE.VALUE('SY$ALL');
33: ELSIF LP_FROM_WAREHOUSE IS NOT NULL AND LP_TO_WAREHOUSE IS NOT NULL THEN

Line 32: LP_TO_WAREHOUSE := FND_PROFILE.VALUE('SY$ALL');

28: LP_FROM_WAREHOUSE := FND_PROFILE.VALUE('SY$ALL');
29: LP_TO_WAREHOUSE := FND_PROFILE.VALUE('SY$ALL');
30: ELSIF LP_FROM_WAREHOUSE IS NOT NULL AND LP_TO_WAREHOUSE IS NULL THEN
31: SOURCEWAREHOUSECP := ' and xf.from_warehouse >= ''' || LP_FROM_WAREHOUSE || '''';
32: LP_TO_WAREHOUSE := FND_PROFILE.VALUE('SY$ALL');
33: ELSIF LP_FROM_WAREHOUSE IS NOT NULL AND LP_TO_WAREHOUSE IS NOT NULL THEN
34: SOURCEWAREHOUSECP := ' and xf.from_warehouse <= ''' || LP_TO_WAREHOUSE || '''';
35: LP_FROM_WAREHOUSE := FND_PROFILE.VALUE('SY$ALL');
36: END IF;

Line 35: LP_FROM_WAREHOUSE := FND_PROFILE.VALUE('SY$ALL');

31: SOURCEWAREHOUSECP := ' and xf.from_warehouse >= ''' || LP_FROM_WAREHOUSE || '''';
32: LP_TO_WAREHOUSE := FND_PROFILE.VALUE('SY$ALL');
33: ELSIF LP_FROM_WAREHOUSE IS NOT NULL AND LP_TO_WAREHOUSE IS NOT NULL THEN
34: SOURCEWAREHOUSECP := ' and xf.from_warehouse <= ''' || LP_TO_WAREHOUSE || '''';
35: LP_FROM_WAREHOUSE := FND_PROFILE.VALUE('SY$ALL');
36: END IF;
37: RETURN SOURCEWAREHOUSECP;
38: END SOURCEWAREHOUSECFFORMULA;
39:

Line 47: LP_FROM_DESTINATION_WAREHOUSE := FND_PROFILE.VALUE('SY$ALL');

43: DESTINATIONWAREHOUSECP := ' and xf.to_warehouse >= ''' || LP_FROM_DESTINATION_WAREHOUSE || '''
44: and xf.to_warehouse <= ''' || LP_TO_DESTINATION_WAREHOUSE || '''';
45: ELSIF LP_FROM_DESTINATION_WAREHOUSE IS NULL AND LP_TO_DESTINATION_WAREHOUSE IS NULL THEN
46: DESTINATIONWAREHOUSECP := ' ';
47: LP_FROM_DESTINATION_WAREHOUSE := FND_PROFILE.VALUE('SY$ALL');
48: LP_TO_DESTINATION_WAREHOUSE := FND_PROFILE.VALUE('SY$ALL');
49: ELSIF LP_FROM_DESTINATION_WAREHOUSE IS NOT NULL AND LP_TO_DESTINATION_WAREHOUSE IS NULL THEN
50: DESTINATIONWAREHOUSECP := ' and xf.to_warehouse >= ''' || LP_FROM_DESTINATION_WAREHOUSE || '''';
51: LP_TO_DESTINATION_WAREHOUSE := FND_PROFILE.VALUE('SY$ALL');

Line 48: LP_TO_DESTINATION_WAREHOUSE := FND_PROFILE.VALUE('SY$ALL');

44: and xf.to_warehouse <= ''' || LP_TO_DESTINATION_WAREHOUSE || '''';
45: ELSIF LP_FROM_DESTINATION_WAREHOUSE IS NULL AND LP_TO_DESTINATION_WAREHOUSE IS NULL THEN
46: DESTINATIONWAREHOUSECP := ' ';
47: LP_FROM_DESTINATION_WAREHOUSE := FND_PROFILE.VALUE('SY$ALL');
48: LP_TO_DESTINATION_WAREHOUSE := FND_PROFILE.VALUE('SY$ALL');
49: ELSIF LP_FROM_DESTINATION_WAREHOUSE IS NOT NULL AND LP_TO_DESTINATION_WAREHOUSE IS NULL THEN
50: DESTINATIONWAREHOUSECP := ' and xf.to_warehouse >= ''' || LP_FROM_DESTINATION_WAREHOUSE || '''';
51: LP_TO_DESTINATION_WAREHOUSE := FND_PROFILE.VALUE('SY$ALL');
52: ELSIF LP_FROM_DESTINATION_WAREHOUSE IS NOT NULL AND LP_TO_DESTINATION_WAREHOUSE IS NOT NULL THEN

Line 51: LP_TO_DESTINATION_WAREHOUSE := FND_PROFILE.VALUE('SY$ALL');

47: LP_FROM_DESTINATION_WAREHOUSE := FND_PROFILE.VALUE('SY$ALL');
48: LP_TO_DESTINATION_WAREHOUSE := FND_PROFILE.VALUE('SY$ALL');
49: ELSIF LP_FROM_DESTINATION_WAREHOUSE IS NOT NULL AND LP_TO_DESTINATION_WAREHOUSE IS NULL THEN
50: DESTINATIONWAREHOUSECP := ' and xf.to_warehouse >= ''' || LP_FROM_DESTINATION_WAREHOUSE || '''';
51: LP_TO_DESTINATION_WAREHOUSE := FND_PROFILE.VALUE('SY$ALL');
52: ELSIF LP_FROM_DESTINATION_WAREHOUSE IS NOT NULL AND LP_TO_DESTINATION_WAREHOUSE IS NOT NULL THEN
53: DESTINATIONWAREHOUSECP := ' and xf.to_warehouse <= ''' || LP_TO_DESTINATION_WAREHOUSE || '''';
54: LP_FROM_DESTINATION_WAREHOUSE := FND_PROFILE.VALUE('SY$ALL');
55: END IF;

Line 54: LP_FROM_DESTINATION_WAREHOUSE := FND_PROFILE.VALUE('SY$ALL');

50: DESTINATIONWAREHOUSECP := ' and xf.to_warehouse >= ''' || LP_FROM_DESTINATION_WAREHOUSE || '''';
51: LP_TO_DESTINATION_WAREHOUSE := FND_PROFILE.VALUE('SY$ALL');
52: ELSIF LP_FROM_DESTINATION_WAREHOUSE IS NOT NULL AND LP_TO_DESTINATION_WAREHOUSE IS NOT NULL THEN
53: DESTINATIONWAREHOUSECP := ' and xf.to_warehouse <= ''' || LP_TO_DESTINATION_WAREHOUSE || '''';
54: LP_FROM_DESTINATION_WAREHOUSE := FND_PROFILE.VALUE('SY$ALL');
55: END IF;
56: RETURN DESTINATIONWAREHOUSECP;
57: END DESTINATIONWAREHOUSECFFORMULA;
58:

Line 66: LP_FROM_TRANSFER_STATUS := FND_PROFILE.VALUE('SY$ALL');

62: TRANSFERSTATUSCP := ' and ge.meaning >= ''' || LP_FROM_TRANSFER_STATUS || '''
63: and ge.meaning <= ''' || LP_TO_TRANSFER_STATUS || '''';
64: ELSIF LP_FROM_TRANSFER_STATUS IS NULL AND LP_TO_TRANSFER_STATUS IS NULL THEN
65: TRANSFERSTATUSCP := ' ';
66: LP_FROM_TRANSFER_STATUS := FND_PROFILE.VALUE('SY$ALL');
67: LP_TO_TRANSFER_STATUS := FND_PROFILE.VALUE('SY$ALL');
68: ELSIF LP_FROM_TRANSFER_STATUS IS NOT NULL AND LP_TO_TRANSFER_STATUS IS NULL THEN
69: TRANSFERSTATUSCP := ' and ge.meaning >= ''' || LP_FROM_TRANSFER_STATUS || '''';
70: LP_TO_TRANSFER_STATUS := FND_PROFILE.VALUE('SY$ALL');

Line 67: LP_TO_TRANSFER_STATUS := FND_PROFILE.VALUE('SY$ALL');

63: and ge.meaning <= ''' || LP_TO_TRANSFER_STATUS || '''';
64: ELSIF LP_FROM_TRANSFER_STATUS IS NULL AND LP_TO_TRANSFER_STATUS IS NULL THEN
65: TRANSFERSTATUSCP := ' ';
66: LP_FROM_TRANSFER_STATUS := FND_PROFILE.VALUE('SY$ALL');
67: LP_TO_TRANSFER_STATUS := FND_PROFILE.VALUE('SY$ALL');
68: ELSIF LP_FROM_TRANSFER_STATUS IS NOT NULL AND LP_TO_TRANSFER_STATUS IS NULL THEN
69: TRANSFERSTATUSCP := ' and ge.meaning >= ''' || LP_FROM_TRANSFER_STATUS || '''';
70: LP_TO_TRANSFER_STATUS := FND_PROFILE.VALUE('SY$ALL');
71: ELSIF LP_FROM_TRANSFER_STATUS IS NOT NULL AND LP_TO_TRANSFER_STATUS IS NOT NULL THEN

Line 70: LP_TO_TRANSFER_STATUS := FND_PROFILE.VALUE('SY$ALL');

66: LP_FROM_TRANSFER_STATUS := FND_PROFILE.VALUE('SY$ALL');
67: LP_TO_TRANSFER_STATUS := FND_PROFILE.VALUE('SY$ALL');
68: ELSIF LP_FROM_TRANSFER_STATUS IS NOT NULL AND LP_TO_TRANSFER_STATUS IS NULL THEN
69: TRANSFERSTATUSCP := ' and ge.meaning >= ''' || LP_FROM_TRANSFER_STATUS || '''';
70: LP_TO_TRANSFER_STATUS := FND_PROFILE.VALUE('SY$ALL');
71: ELSIF LP_FROM_TRANSFER_STATUS IS NOT NULL AND LP_TO_TRANSFER_STATUS IS NOT NULL THEN
72: TRANSFERSTATUSCP := ' and ge.meaning <= ''' || LP_TO_TRANSFER_STATUS || '''';
73: LP_FROM_TRANSFER_STATUS := FND_PROFILE.VALUE('SY$ALL');
74: END IF;

Line 73: LP_FROM_TRANSFER_STATUS := FND_PROFILE.VALUE('SY$ALL');

69: TRANSFERSTATUSCP := ' and ge.meaning >= ''' || LP_FROM_TRANSFER_STATUS || '''';
70: LP_TO_TRANSFER_STATUS := FND_PROFILE.VALUE('SY$ALL');
71: ELSIF LP_FROM_TRANSFER_STATUS IS NOT NULL AND LP_TO_TRANSFER_STATUS IS NOT NULL THEN
72: TRANSFERSTATUSCP := ' and ge.meaning <= ''' || LP_TO_TRANSFER_STATUS || '''';
73: LP_FROM_TRANSFER_STATUS := FND_PROFILE.VALUE('SY$ALL');
74: END IF;
75: RETURN TRANSFERSTATUSCP;
76: END TREANSFERSTATUSCFFORMULA;
77: